Welcome to MSDN Blogs Sign in | Join | Help

August 2009 - Posts

No new features in for Integration Services in SQL Server 2008 R2

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. There
Posted by mmasson | 5 Comments

SQL PASS 2009

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
Posted by mmasson | 0 Comments

Looking up SSIS HResult / COMException ErrorCode

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,
Posted by mmasson | 0 Comments
Filed under:

Debugging a COMException during package generation

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.Runtime.InteropServices.COMException
Posted by mmasson | 0 Comments
Filed under:
 
Page view tracker