- Copys 4 files to local (All 4 files have dynamic file names which are todays date)
- Emails the files (SendMail has been designed to look for these dynamic files)
Now I have created a job to run the SSIS Package...
This fails on the 'Send Mail' Tasks
does not exist or you do not have permissions to access the file.
End Error Error: 2009-01-26 11:33:50.09 Code: 0xC0024107
Source: Send Mail Task 1 Description: There were errors during task validation. End Error DTExec: The package execution returned
DTSER_FAILURE (1). Started: 11:33:49 Finished: 11:33:50 Elapsed: 0.891
seconds. The package execution failed. The step failed.
1. If I check in the local folder the files are there!
2. If I run the SSIS package manually within SSBID it works fine....