Welcome to EMC Consulting Blogs Sign in | Join | Help

Browse by Tags

All Tags » SSIS » SP2
  • SSIS: Service Pack 2 improvements

    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 ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on February 8, 2007
  • SSIS RetainSameConnection bug and SP2

    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 & ...
Powered by Community Server (Personal Edition), by Telligent Systems