|
|
Browse by Tags
All Tags » SQL Server Inte... » connection mana... » Nugget
-
As some of you may know I've been writing about SSIS on this blog for a lon-n-n-n-n-g time now. Too long it seems sometimes. In all that time though I've only had one short client engagement using the product which means that my real-world experience is somewhat limited. Studying something is all well and good but there's nothing quite like ...
-
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 ...
|
|
|