Update 2009-11-12 : One minor feature change announced . Have you been holding your breath waiting for Microsoft to announce the new SSIS features for SQL Server 2008 R2 ? The answer is pretty simple – nothing new is being added for SSIS in R2....

I was just looking at the sessions for the SQL PASS 2009 Summit and was happy to see so many SSIS presentations on the list! Andy Leonard Applied SSIS Design Patterns Steve Simon SQL Server Integration Services and the modern financial institution Davide...

The method I describe in my post about handling COMExceptions during package generation works if you have control over the package generation code, but sometimes you’ll be using third party libraries, or debugging after the fact. Note, the error codes...

You’ll occasionally receive a COMException when you’re programmatically generating SSIS package – typically when dealing with Data Flow components. These COM Exceptions will provide you with an HRESULT (ErrorCode), and no additional information. System...