I'm looking for any and all information on how to execute an SSIS package from my asp.net web site. I have written the call and when I run the application from (Localhost) it works, but when I run it from the server it does not.
Here is my code to call and execute the package:
public string ProcessFiles(int ClientID, string FileName)
{
//System.Security.Principal.WindowsImpersonationContext impersonationcontext;
//impersonationcontext = ((System.Security.Principal.WindowsIdentity)ServiceContext.User.Identity).Impersonate();
string packagePath = "\\\\10.0.1.100\\Customer File Import.dtsx";
Microsoft.SqlServer.Dts.Runtime.Application app;
Microsoft.SqlServer.Dts.Runtime.Package pkg;
Microsoft.SqlServer.Dts.Runtime.Variables vars;
Application integrationServices = new Application();
DTSExecResult result;
...
Go to the complete details ...