job failed to execute SSIS package
I am using SQL server 2008 integration services. I created the package which works fine while executing from SSIS manually But when i created the job then its failed. If I gave local path in the package for extracting the files then its works fine and job success but if i gave the network path then its failed. I know that its kind of comman problem. I am new in SSIS. Please guide me with some solution. I tries using the proxy account but stilll its failed. Thanks In Advance.
February 11th, 2011 10:27am

When referring to the network path you are using the UNC (\\computer\SharedFolder)? You are certain that the proxy account can access the network path from the computer where the job runs the package?Russel Loski, MCT
Free Windows Admin Tool Kit Click here and download it now
February 11th, 2011 10:32am

Thanks for you quick response. Yes Russel I am referring the path as you mentioned(\\computer\SharedFilder). But Can you please guide me that How can i checked that my proxy account can access that path or not. I am using window authentication.
February 11th, 2011 10:46am

Examine the security settings of your share. Also as a test, you can try to run a process using Run As command against this target from your source. If the security is fine, then we need to see the error message from the package.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
February 11th, 2011 10:51am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics