blogs.conchango.com

Here is the next in my series of posts explaining how common tasks in DTS can now be implemented in SSIS.Use multiple connection objects in order to maintain seperate connections to a database It was commonly recommended in DTS that a package should contain multiple connection objects pointing to the same database if you had multiple ...

Many people like to use stored procedures as the source of data for the SSIS pipeline. In theory there is nothing wrong with that however it does have its complications. Depending on the way the stored procedure is written, it may or may not be suitable to be used in this way. Namely, it is possible to preview the data being returned from a stored ...

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 ...