asked
SSIS fails as scheduled job
Hi - I have a package which works fine when running in ssis but fails in sql. I am trying to move files from one folder to another using File System Task inside a For Each Loop container. The variables are mapped to the specific folders. But the error when I run it in sql is Could not find file 'C:\\Program Files\\Common Files\\SYSTEM\\MSMAPI\\1033\\Confirmation_2654.xml. Any help would be greatly appreciated!
Hi AUD, does it say anywhere about permissions? It might be the account running the agent job does not have permissions to read the file, try creating credentials and a proxy account, then change the "Run As" user in the job step.
I will try that. But perhaps I wasn't clear in my explanation. there is a variable which points to c:\folder which is where the file is. The folder is found when running the packing in SSIS. When the job is run through sql the error is that it can't find the file but it's looking in C:Program FilesCommon FilesSYSTEMMSMAPI1033. It seems to not see my variable. I'm sorry if I'm not making sense. I'm new at this.
When you have the package open in BIDS, and you click on a blank area of the control flow, then press F4 to open the properties window, what is the value for "ProtectionLevel"?
