Email Output Excel File

  • 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)

  • doesn't matter I worked it out, add the email task after the condition export so it only emails if the previous task runs.

  • 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