I am having a problem running an ssis package from a service written in C#.
Here is my code
try
{
//Package Path
string packagePath = @"C:\\data_from_listcleanup\\programmability\\Package.dtsx";
//create an instance of the package
Package goPackage = new Application().LoadPackage(packagePath, null);
//execute package
DTSExecResult result = goPackage.Execute();
//write results to file
m_streamWriter.WriteLine("Package Execution Results: {0} \n", result.ToString());
}
catch (Exception ex)
{
m_streamWriter.WriteLine("Error from dts: {0} \n", ex.ToString());
}
it does not go to Exception it just fails.
The txt file just says it fails.
I can run the package on my own and it runs fine so the package is good. This is my first time writing a call to an ssis package from code so I may be doing it completely wrong...
Thanks in advance!