DTS package to send mail as attachemnt

• jma100

  Mr or Mrs. 500

  Points: 576

  More actions

  April 11, 2003 at 4:59 am

  #159089

  Hallo friends

  I have the following problem.

  There is dts package which using activex script(vbscript) to send all the excel files from particular directory to a email address specified as attachments. I am using outlook as application to send the mail. The dts job is functioning well when I have tried to run in DTS package editing screen. But the same package gives the following error when I tried to run the same as a Job

  "

  Source of error = Microsoft Outlook

  error description: The procedure could not successfully be closed, since it is not supported by the service provider.

  "

  I am using system account to test this job.

  The excel datei stored in a local directory

  in SQLserver.

  When I tried to run this job without attachment, its works fine.

  Probably problem with attachment.

  Any ideas to solve this problem??

  Best regards

  Joseph

• jfb

  SSCrazy

  Points: 2469

  More actions

  April 11, 2003 at 3:21 pm

  #453953

  Hi,

  Personally I don't like to use outlook inside SQL.

  Incorporate the tool in the link and you wont have any more problems.

  http://sqldev.net/xp/xpsmtp.htm

  JFB