DTS package to send mail as attachemnt

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply