send mail doesn't 'see' created file

Last Post 31 Jul 2007 03:04 AM by cronid. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
cronid
New Member
New Member

--
28 Jul 2007 02:50 AM
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?
cronid
New Member
New Member

--
31 Jul 2007 03:04 AM
The first step is not executing. The job is failing on the job validation before either task is executed.
You are not authorized to post a reply.

Acceptable Use Policy