Tuesday, October 8, 2013

Run SSIS package from C# 4.0 VS 2010

        Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass app = new Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass();
        string packagePath = @"C:\Users\kumaraje\Documents\Test SSIS.dtsx";
        Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackage100 package = app.LoadPackage(packagePath, true, null);
        package.Execute(); 

No comments: