Error while reading file modified date via SQL Job

• ah0996

  SSC Veteran

  Points: 212

  More actions

  September 26, 2016 at 12:45 pm

  #321692

  Hi,

  I have C# script that reads last modified date of file. Script works perfectly fine while running manually from package. However, when I deploy the script/package to SQL job. I generates error. Any suggestions?

  Thank you for help in advance

• Phil Parkin

  SSC Guru

  Points: 247099

  More actions

  September 26, 2016 at 12:51 pm

  #1903185

  ah0996 (9/26/2016)

  ---

  Hi,

  I have C# script that reads last modified date of file. Script works perfectly fine while running manually from package. However, when I deploy the script/package to SQL job. I generates error. Any suggestions?

  Thank you for help in advance

  Probably a permissions issue. Check that the SQL Agent user has the necessary permissions to be able to read the file.

  ---