A question on export

[pzhou]

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.
Your help is appreciated.

--Ping

 

[mrdenny]

Please don't cross post.

See my response in forum183.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com