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.