Cannot open data file sql server agent error

• bpsavi123

  SSC-Addicted

  Points: 499

  More actions

  June 12, 2015 at 10:18 am

  #301519

  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.

• AlexSQLForums

  SSChampion

  Points: 14277

  More actions

  June 12, 2015 at 1:12 pm

  #1805213

  Make sure SQL Agent account has Modify permissions.

  Alex S