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?
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.
The absence of evidence is not evidence of absence - Martin Rees The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response - Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply