0

I have a an SSIS solution that runs fine in BIDS. However, once I try to deploy it to the server and execute through SQL Server Agent, it fails with:

Cannot access datafile...

Details:

server: localhost that I built sysadmin: my local domain account is the sysadmin using Windows Authentication filepath: my local C:\Users\me\Downloads

I have tried mapping my login to a credential and using that credential as a proxy, but it still fails.

Can someone help with a step-by-step solution as to how to make sure the SQL Server Agent account has access to write and read files on my local file directory?

Pablo Boswell
  • 805
  • 3
  • 13
  • 30

1 Answers1

0

look that：

enter image description here

What is the service account for SQL Server Agent? Is has privilege to access operation sytem?

Prahalad Gaggar
  • 11,389
  • 16
  • 53
  • 71
Joyson
  • 84
  • 2