Parallelism in SSIS

Hi,

I would just like to confirm something with you guys...

Am I correct in saying that you dont need multiple connections to the same DB in a SSIS package in order to achieve parallel processing across multiple SQL tasks. In other words, I have 2 SQL tasks executing different stored procedures on the same DB that I want to run in parallel. They should be able to share one connection and still process in parallel, correct?

With that in mind, would the processing be faster if they each had their own connection?

Thanks in advance.

GBez wrote:

Hi,

I would just like to confirm something with you guys...

Am I correct in saying that you dont need multiple connections to the same DB in a SSIS package in order to achieve parallel processing across multiple SQL tasks. In other words, I have 2 SQL tasks executing different stored procedures on the same DB that I want to run in parallel. They should be able to share one connection and still process in parallel, correct?

They can share a connection manager but they still maintain seperate connections to the database. This is a good thing by the way.

GBez wrote:

With that in mind, would the processing be faster if they each had their own connection?

No. it wouldn't make any difference.

-Jamie

Parallelism - Standard vs Enterprise Edition

We were told by a Microsoft representative that Intraquery Parallelism is
available only in the Enterprise Edition of SQL 2005. Can anyone confirm den
y
that and support with documentation?
Standard fits our needs all other features, but I don't want to lose
Intraquery Parallelism.
TerryIntraquery parallelism is available in all editions which supports > 1 proce
ssor. There are only
certain type of operations going over several processors that only EE can do
. See
http://www.microsoft.com/sql/prodin...e-features.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Terry" <Terry@.discussions.microsoft.com> wrote in message
news:0081E754-B590-43F2-B571-06526EF3C270@.microsoft.com...
> We were told by a Microsoft representative that Intraquery Parallelism is
> available only in the Enterprise Edition of SQL 2005. Can anyone confirm d
eny
> that and support with documentation?
> Standard fits our needs all other features, but I don't want to lose
> Intraquery Parallelism.
> Terry

Parallelism - Standard vs Enterprise Edition

We were told by a Microsoft representative that Intraquery Parallelism is
available only in the Enterprise Edition of SQL 2005. Can anyone confirm deny
that and support with documentation?
Standard fits our needs all other features, but I don't want to lose
Intraquery Parallelism.
TerryIntraquery parallelism is available in all editions which supports > 1 processor. There are only
certain type of operations going over several processors that only EE can do. See
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Terry" <Terry@.discussions.microsoft.com> wrote in message
news:0081E754-B590-43F2-B571-06526EF3C270@.microsoft.com...
> We were told by a Microsoft representative that Intraquery Parallelism is
> available only in the Enterprise Edition of SQL 2005. Can anyone confirm deny
> that and support with documentation?
> Standard fits our needs all other features, but I don't want to lose
> Intraquery Parallelism.
> Terry