August 22, 2011 at 10:12 pm
Hi All,
I have a package that runs a SQL statement, then does some formating(dervied columns), some changing of date types then if variable @rowcount has results exports the data to a folder\excel file where a FTP uploads to another server.
I would like to add to this a step where if there are results email them, can some tell me how I do this?
Control Flow
file system task(copy from excel template over excel file)
|
|
|
Data flow task(sql statement, formating,row count, make connection to excel)
|
|expression @rowcount>0
|
File system task(copy file to folder)
August 22, 2011 at 10:34 pm
doesn't matter I worked it out, add the email task after the condition export so it only emails if the previous task runs.
August 23, 2011 at 9:04 am
Hi,
After the @rowcount > 0 constraint, add a Send Mail Task to communicate to relevant people.
Alternatively you can use a Script Task to send the notification as well as attachments if any.
Hope this helps you.
Regards,
Durga
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply