5

I've run into this twice now where I can run my SSIS package in BIDS and Integration Services but it fails when it's run through SQL Server Agent. Both of these packages transfer a file as a final step to a folder on our network.

The error I receive is Could not find a part of the path then the path and file name. When I schedule them in Windows Task Scheduler they execute fine but I'd rather have them run through sql server agent.

Has anyone run into this issue and found a work around? Is there a setting that I'm missing in sql server?

Any help would be appreciated.

kdejarnet
  • 149
  • 1
  • 2
  • 8

1 Answers1

8

You need to run the SQL Server job using a proxy account that is configured to run jobs of type SQL Server Integration Services Packages. The jobs usually run under SQL Server Agent Service account, which does not have access to network folders. To access network folders, you need to set up a proxy with a domain account credentials (preferably) so you can access network path.

Below answer in SO question has the detailed steps on how to set up a proxy account

How do I create a step in my SQL Server Agent Job which will run my SSIS package?

Community
  • 1
  • 1
  • Thanks Siva. I've set up the proxy with a domain account that has access to the network and am running the package under that credential but am still getting the same error. Unsure why at this point. Any suggestions? – kdejarnet Feb 05 '13 at 22:09
  • 1
    Yes, just figured it out. I needed to use a UNC path in order for it to work. I was trying to use a mapped drive (e.g. z:\filepath) and needed to use \\servername\filepath. Once I made that change it works perfectly. Thanks a lot for your help. – kdejarnet Feb 06 '13 at 20:24