Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cronid
Starting Member
26 Posts |
 Posted - 2007-07-28 : 07:46:13
|
| I have a number of jobs which in step one create a flat file from my databases using an expression to insert the date (yyyy-mm-dd) within the file name. I am then in step two using send mail to send those files to my users, again using an expression to reference the attached file. When the first step's file is already created and I'm overwriting, the job runs fine either manually within Business Studio or as a scheduled job via SQL Agent. But when the files are being created in step one, the job fails validation with the message that the send mail file attachment doesn't exist! SSIS doesn't seem to recognize that the file is being created in the prior step. Could this be true? Or is there some other problem that I'm missing? |
|
|
tmitch
Yak Posting Veteran
60 Posts |
Posted - 2007-07-30 : 00:08:16
|
| Do you have the tasks linked to make sure that the one you expect to run first actually does? If you don't link the tasks, they will both try to run simultaneously, which could cause your "file not found" problem.hthTim |
 |
|
|
cronid
Starting Member
26 Posts |
Posted - 2007-07-31 : 08:02:07
|
| The tasks are linked. |
|
|
|
|
|
|
send mail doesn't 'see' file create