I'm just learning how to use DTS now and it looks like it might solve the
issue I'm currently dealing with.

What I want to do is set up SQL Server 2k to export data from a specific
database and specific table and dump it into an excel spreadsheet - and have
it automated to do it daily at xx hour. I'm thinking I can do this with DTS
and if so, sounds great..but I'm very new to DTS. I should ask..is this even
possible - and if so - how? Follow the wizard? any websites that discuss it
in detail?

Thanks.

Hello SteveS,

This is definitely possible.

You will build a package that does the export
You will schedule it using SQL Server Agent (Although it can be any scheduling
package)
Your syntax will use DTSRun

Here are some articles to get you going

http://www.sqldts.com/default.aspx?278
http://www.sqldts.com/default.aspx?276
http://www.sqldts.com/default.aspx?301


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Allan - thanks for your reply. Exactly what I looking for and it helped me
create my first package and have it automated. DTS is great for what I need
it for.

"Allan Mitchell" wrote: