DTS Utility

zy_abc
04-16-2004, 05:33 AM
Hello All,

I would like to Export data from SQL Server 2000 to a Delimited Text File using DTS Utlity (Import Data & Export Data). I am able to do DTS from SQL Server to SQL Server but i don't know how to export the data to the text file. Pls point me in right direction.

MKoslof
04-16-2004, 07:18 AM
A nice place to start is here: http://www.dtssql.com

What code do you have so far?

zy_abc
04-16-2004, 10:28 PM
Thanks for your reply.

The link which you gave didn't work. Further, i would like to do DTS directly in SQL Server 2000. Can you please explain me how to do DTS to transfer the data from the table to a flat file.

zy_abc
04-17-2004, 01:13 AM
Thanks for your reply.

The link which you gave didn't work. Further, i would like to do DTS directly in SQL Server 2000. Can you please explain me how to do DTS to transfer the data from the table to a flat file.

Problem Solved !!! Works Perfectly !!!

MKoslof
04-19-2004, 06:34 AM
I was offline for a while, sorry :). For future notice, here is the correct link:

http://www.sqldts.com/

I got my letters mixed up, typing too quick. I have done some dts work in my day, if you have another question, feel free to post again.

zy_abc
04-20-2004, 12:02 AM
I was offline for a while, sorry :). For future notice, here is the correct link:

http://www.sqldts.com/

I got my letters mixed up, typing too quick. I have done some dts work in my day, if you have another question, feel free to post again.

Thanks for your help MKoslof. If i have further doubts, i will post by doubts.

MKoslof
04-20-2004, 06:05 AM
No problem, good luck

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum