Cannot open data file sql server agent error

  • I have package which works fine in BIDS.But the same when run as a sql server agent gives and error cannot open data file from a flat file path.I dont see any permission issue.

  • Make sure SQL Agent account has Modify permissions.

    Alex S

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply