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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.