ssis package in C#

[User 4005525]

Hi all, I've created a SSIS package and Loaded using C# windows application.I've imported configuration file also. but while exexute that loaded package it returns failure result. I dont know why? But it's working with BI and returns the result successfully. package.Execute() returns failure. Can anyone tell me how can i solve this issue? i have placed the code which i have used in my application. Application app = new Application(); Package package = app.LoadPackage("c:\\Example.dtsx", null); package.ImportConfigurationFile("c:\\Example.dtsConfig"); Variables vars = package.Variables; vars["Name"].Value = name.text.trim(); DTSExecResult result = package.Execute(); Console.WriteLine("Package Execution results: {0}",result.ToString());