Post reply

dynamically adds a file to a sendmail task

  • May 18, 2005 at 9:01 pm

    #164645

    hi,

     

    can anyone tell me how to dynamically attach a file to sendmail task inside dts? my dts does the following steps in order:

    1. runs the query

    2. dumps the data in an excel file

    3. activex script renames the file.

    4. runs a sendmail task.

    but how can i specify as attachment to the sendmail task the result of step #3.

    thanks and regards.

    ann

  • May 18, 2005 at 9:39 pm

    #559766

    The atttachments for the send mail is simple a semi colon separated list of file names. I would create a global variable to contain the list of files and use this variable in a dynamic properties task to update the attachments for sendmail task

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply