From the nature of your question, it would be good for you to spend some
time in the DTS section of BooksOnline, or with a good SQL Server book.
One that I like is Rob Vieira's "Professional SQL Server 2000 Programming".
It has a decent section or two on DTS programming.
The short answer is that you set up two connection objects. The Source
connection should be to your SQL Server database. The Destination
connection would map to either an Excel or Text file. Then you set up a
DataPump transformation task between the two. Of course, you'll have to
parameterize your connections dynamically if this gets deployed to multiple
This really is too big an issue to address in detail in this format. Trust
me that there are good books and online documentation that will help you
through the process.
Realize also that you don't need DTS to accomplish an export. Check out the
OPENQUERY function in Books Online. Using a linked server and this call,
you can accomplish the same thing if it's a simple scenario.
Quote:> Hi All,
> I have a question how I can export data in table to text
> file or excel file in DTS package. So, I can schedule a
> job to run this package automatically according to our
> Thanks in advance!