DTS Package sending attachment AFTER rename

• CV Eaton

  SSC Enthusiast

  Points: 105

  More actions

  May 5, 2004 at 10:13 am

  #60101

  Learning a thing or two about DTS Packages/ActiveX and SMTPMail.  I have a package right now that Creates a Table, creates a text file from that table then renames it so the current date is at the end (testfile05052004.txt).  I then want to send it using the smtp mail, but have to specify the file name, but I'm confused how I can specify the file name for the attachment within SMTP if I am changing it every time the file is created.  Any help would be great!  Thanks.

• philcart

  SSC-Forever

  Points: 47795

  More actions

  May 6, 2004 at 3:00 am

  #505427

  We do this regularly in a number of packages. All in an ActiveScript task.

  The filename is stored in a global variable which is used when attaching the file to the email.

  --------------------
  Colt 45 - the original point and click interface