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

There have been a few posts on the SSIS MSDN Forum asking how one can create and use SQL Server temporary tables within SSIS packages.   Temporary tables are tables that are created within a session and live for the life of that session or until all sessions using it have ended. They are denoted by either having a hash (e.g. ...

We have an AS400 source system and can only use ODBC connections to access it. We also need to set RetainSameConnection to true since we're initializing the AS400 connection with a number of temporary aliases that will be used by later Data Flows and Execute SQL Tasks. Turns out that when using the ODBC driver in SSIS with Execute SQL & ...

A post appeared on the SSIS forum today in which the poster was getting slightly confused about the use of SSIS Connection Managers and how they differ from DTS Connections so I thought it would be a good idea to illustrate the differences here to hopefully save anyone else from having the same headaches. A problem with DTS Connections was ...

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