question

paws27284 avatar image
paws27284 asked

Will multiple exec SP calls within a single SSIS sql task execute at the same time?

I am reveiwing some one else's package. They have 4 exec sp statements in a single SQL Task in SSIS 2008 r2. SP 1 must execute before sp2, sp3 and sp4. Will this scenario execute all 4 SPs at the same time or in the sequence they are ordered in the SQL task? I think they should separate them and have a secondary SQL Task dependant upon the first. SQL task 1 calls SP1 and then SQL task 2 calls SP2,SP3,SP4. I don't want to change it if the only reason for the change is my preference, not performance. Thanks! Paws
ssissql-server-2008-r2
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
KenJ avatar image
KenJ answered
The statements will be executed sequentially just as if you executed them from SSMS. Your desired method, while it does provide more transparency into what the package is doing, is just a preference and will have no performance benefit.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.