How to copy data from table to the flat file.
-
Hello,
In SQL 2000 I use DTS package to import data to the flat file.
How can I do in SQL 2005?
Can I create the job then will run BCP utilities or something else to output date?
Mark
-
You can use SSIS - i.e. launch SQL Management Studio, expand databases, right-click database, go to tasks, select export data.
Tommy
Follow @sqlscribe -
Thanks. But its import data between dbs.
How to import data from table to local C: drive in csv format?
-
Thanks I got it
-
NP
Tommy
Follow @sqlscribe
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply