DTSSendMailTask Attachments

• sqletom

  SSC-Addicted

  Points: 438

  More actions

  January 30, 2004 at 8:16 am

  #59189

  Hi everyone!

  I have created lots of DTS packages many that email out attachements (reports etc.). In some packages the attachment file is hard coded and in others I set the attachment property dynamically.  The problem is, if the file is on a fileserver in some subdirectory the whole path gets translated as the attachment filename example:

  attachment: "\\fileserver\directory\subdirectory\file.txt"

  is translated as "fileserver_directory_subdirectory_file.txt" and not just "file.txt"

  This seems to only happen with emails sent outside of our domain. Has anyone else seen this, have any ideas for resolving this?

  Thanks in advance!!! Tom.

• February 2, 2004 at 8:00 am

  This was removed by the editor as SPAM

• ray_higdon

  SSCarpal Tunnel

  Points: 4589

  More actions

  February 3, 2004 at 11:03 am

  #492655

  There are some quirky things with dtssendmail task, I prefer using a SQL command to call xp_sendmail. You have more control.

  ------------
  
  Ray Higdon MCSE, MCDBA, CCNA