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.