We try to execute our SSIS packages from a .NET application. It works fine until we use “Expressions ” inside Data Flow’s components like “ADO NET Source” (e.g., for building SQL statements)
I use the ADO NET Source Control and want to set the SqlCommand property with an expression holding a SQL statement.
When executing the SSIS package in Visual Studio (in debug mode) I get no problem, everything works fine. When executing the package from within my .NET application it crashes the app completely, only creating a generic
Win32 Exception with no relevant information.
I created new SSIS package.
Then added the Data Flow component.
Inside Data Flow I added “ADO NET Source&
View Complete Post