Calling SSIS package from web service -
10-18-2006
, 03:39 AM
Hi,
I've been struggling for a few days now with this problem and hope someone
can help.
I have an SSIS package which i want to run from a C# application. Upon
searching the web for possible solutions i came across the idea of calling it
from a web service. I have set up a web service which calls the package and
on the local development machine this works fine. It seems to execute the
SSIS package as the local ASPNET account of the PC upon which it is running.
I have set up ASPNET account in SQL server and given it access to the
relevent databases etc.
The problem seems to come when i deploy it and try to access file system
locations via the File system tasks that are on other PC's. I am assuming
that because the pacakage is being run under the ASPNET account that this
does not have any permissions to remote PC drives.
Can anyone suggest a way in which i might configure the web service/SSIS
package so that when it is run it has rights to access remote file system
shares etc.
Any help on this would be most appreciated. If any more detail i required i
will be happy to re-post.
Thanks in advance,
Grant |