April 11, 2003 at 4:59 am
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
April 11, 2003 at 3:21 pm
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