email task problem

• solus

  Hall of Fame

  Points: 3495

  More actions

  January 8, 2010 at 7:07 am

  #144074

  I have an email task setup to send an email in the 'OnTaskFailed' event of a package.

  This works ok and an email is sent if any task in the package fails.

  if I subsequently specify a file attachment, the email isnt sent !

  The file im specifying as the attachment does exist

  has anyone else experienced problems like this ?

  Im using an expression

  FileAttachments @[User::SSISLogFileLocation]+ "\\test_SSISLog.txt"

  the expression evaluates to

  C:\Import\LogFiles\test_SSISLog.txt

  this is a valid path and the text file exists at that location

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  January 8, 2010 at 9:14 am

  #1100962

  Do you get an error message?

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/