Some questions about coding ActiveX Script/VBScript in SQL Server Agent Jobs/DTS packages
 
Hi,
   
I use SQL Server Agent Jobs/DTS packages, coded in ActiveX Script/VBScript.
It works fine.
   
   
But there are some issues I would need help at the moment:
   

- First: Is there a possibility to send an html email out of the ActiveX Script code in the DTS Step?

My company doesn't want to buy a separate commercial DLL for sending smtp email .. like JMail for example.
I know there are many such DLLs I could buy which can be used to send an email using VB or other languages.
But we don't have the money for such external components.
   
Could I use SQL Server Database Mail?
... but it is necessary to send the mails in html ...
 
 
- Is there a possibility to create a new *.txt, *.csv or *.xlsx file from the ActiveX Script/VBScript code in the DTS

Step?
    
    
I would like to copy the html email body code (a string which I built in the ActiveX Script code) into these files and

attach them to the email I send out of the script code. So the user/recipient gets the html content embedded in the

email body and separate in files too.
    

Thanks in advance for your help.
 

Tommy
 
April 21st, 2015 1:31am

Yes Database mail can be used, in-fact it has very good support for adding HTML tags or formatting the content so that the mail body looks rich. Let me know if you need further help

Good Luck !

Free Windows Admin Tool Kit Click here and download it now
April 21st, 2015 2:08am

You can try this

http://p2p.wrox.com/sql-server-dts/50792-sending-html-emails-through-dts.html


April 21st, 2015 2:21am

Hi,

it works fine. Thanks for posting the URL.

Tommy

Free Windows Admin Tool Kit Click here and download it now
May 5th, 2015 1:48am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics