Post reply

rowcount in the subject line of a Send Mail Task.

  • March 26, 2003 at 5:24 pm

    #105602

    I have a package that exports data into an Excell file. The filename is always the same.

    Is there a way to out in the rowcount in the subject line of the Send Mail Task

  • March 27, 2003 at 6:31 pm

    #452411

    You would need to get the rowcount ahead of time, and use a variable to pass it in as the subject line. It's simple enough, but you will be running your query twice, (once for the count, once to attatch to your mail) to get it to work right. If it's worth it to you, there's how to do it....

    Edited by - scorpion_66 on 03/27/2003 6:31:47 PM

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

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