Thanks everybody for the responses.
when I used DTS designer, I got the following error when I use the Sendmail task.
Unable to get MAPI profile
So I'm going to try to use BCP to do it.
For the ActiveX script, I will save it for the last.
Cheers,
--Ping
Hi sql server experts,
I'd like to get some help on this.
I need to export a table to a .csv file and email the file to somebody. This should happen once a month automatically.
How do I do this? Should I do this with T-SQL?
Is there a package or tool?
I tried DTS but there is no way to email...
Hi sql server experts,
I'd like to get some help on this.
I need to export a table to a .csv file and email the file to somebody. This should happen once a month automatically.
How do I do this? Should I do this with T-SQL?
Is there a package or tool?
I tried DTS but there is no way to email...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.