blogs.conchango.com

For those of you interested in what's new in SSIS in service pack 2, here are a couple of resources: New Features: http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/WhatsNewSQL2005SP2.htm#BKMK_IntegrationServices Bug fixes: http://support.microsoft.com/default.aspx/kb/921896 Note that in SP1 there were alot ...

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