Failure Executing SSIS package from C# on two separate servers
Posted on 2009-02-22
I have a ssis package on SQL Server machine.
I wrote a C# webservice that loads the package and then executes it.
when I installed the webservice on the IIS of a different server the execution returns DTSExecResult.Failure.
I tried creating a new Application Pool and set its Identity to Configurable, and gave it a domain user which is Administrator on the SQL Server machine and has access to the package.
Still no luck....
What kind of user & permissions do I need to define?
I would appreciate any help...