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