|
|
Browse by Tags
All Tags » SSIS » RetainSameConne... » connection mana... » Nugget
-
Did you know....
...that you can run regular SQL Server transactions in SSIS over multiple tasks without requiring the use of Distributed Transaction Coordinator (DTC)? Well I didn't but thanks to that man again, Kirk Haselden, I do now.
The default behaviour of a Connection Manager is that every task has its own connection which is why they ...
|
|
|