Link to home
Start Free TrialLog in
Avatar of sihua
sihua

asked on

create email message from SQL and dump it in inetpub

I need to compose an email message with a csv file attachment and dump it to pickup folder of the inetpub. I couldn't use SQL xp_sendmail because there's no outlook in the server or other MAPI elements. Any idea how to do it in SQL? I already have a DTS which generate the csv the file and I need to send the file out through email?
Avatar of tobydavid
tobydavid

You should be able to send the mail using SMTP, which I prefer to MAPI, anyway.  I do not have the code at my current location, but I should be able to send it along, tomorrow.
There are actions within DTS to send files to difeent detinations, icluding an email address. Don't have exact details, but online help should provide this.
ASKER CERTIFIED SOLUTION
Avatar of tobydavid
tobydavid

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial