Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Problem executing SSIS from C#

Author  Topic  hagaihe Starting Member 1 Post Posted - 2008-06-02 : 05:53:40 Hello, I keep getting "Failure" when I try to execute package from file system and can't find the reason ( user privileges , applicative problems etc) My code looks like this – Application app = new Microsoft.SqlServer.Dts.Runtime.Application(); Package package = app.LoadPackage(@"C:\Temp\<packageName>.dtsx", null); package.ImportConfigurationFile(@"C:\Temp\<packageConfigFile>.dtsConfig"); Variables vars = package.Variables; vars["dbConnection"].Value = dbConnectionString; DTSExecResult result = package.Execute(); MessageBox.Show(String.Format("Package Execution results: {0}", result.ToString())); Any expert suggestions?