SendMail

• Jeremy Kemp

  SSCertifiable

  Points: 6754

  More actions

  October 23, 2003 at 4:28 am

  #106802

  I have a DTS package which loads in a text file, processes it and sends an email on completion.

  I want to include in the email some info about the file processed (e.g. number of rows added, control totals etc).

  The task name is CompletionMail and the global variable containing the info is strCompletionMail so I think I sould be able to do somethine like this:

  CompletionMail.MessageText = DTSGlobalVariables("strCompletionMessage").Value

  This doesn't work and I have tried a number of variations but no joy.

  Any ideas?

  Thanks

  Jeremy

• Jeremy Kemp

  SSCertifiable

  Points: 6754

  More actions

  October 23, 2003 at 5:38 am

  #479245

  I've found an answer to this. I wasn't setting up the Task Collection properly.

  Jeremy