I made a installer program in C# that deploy ssis package on a SQL server 2005. I have like 50 package that contain only dataflow to update a datawarehouse and create fact tables.
I made also one package that call all the other packages. When I try to deploy the packages on the SQL server with the command SaveToDtsServer, I receive an error
BUT only on the package calling all the other SSIS package ??
All the other SSIS packages are deployed but the package that call other packages failed to deploy. Whats strange is that when I use the domain controler to deploy the package (I use Impersonation in my C# code)
its all working fine, but if I use another user (like the computer admin account), I got the error only on the package calling other packages ???
Can anyone help me on that ? I really don't know whats happening ?
The error that i have is : The file can't be found. But like I said, when using the domain controler user for impersonation, its working ???
imp = new Impersonation(session["DBMASTER"], session["DBMASTER_PWD"]);
View Complete Post