May 24, 2007 at 12:56 pm
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
May 24, 2007 at 1:03 pm
You can use SSIS - i.e. launch SQL Management Studio, expand databases, right-click database, go to tasks, select export data.
Tommy
Follow @sqlscribeMay 24, 2007 at 1:26 pm
Thanks. But its import data between dbs.
How to import data from table to local C: drive in csv format?
May 24, 2007 at 1:30 pm
Thanks I got it
May 24, 2007 at 1:31 pm
NP
Tommy
Follow @sqlscribeViewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply