Export as data file from table

• sugan

  SSC-Addicted

  Points: 492

  More actions

  April 6, 2009 at 1:13 am

  #384291

  Hi,

  Now we are using SQLDMO for export and import data in SQL server 2000.

  But this option may not work in future so we need to change the function accordingly.

  Do we have any option to export / import of data to flat file?

  Is this future is availabe in SQL Bulk Copy? In my knowledge sqlbulk copy and SMO is copy the data from source to destination table but it will not create any data file (flat file). i need a function which can able to export / import data from source to destination table using flat file.

  Please give me the solution for this problem.

  Thanks.

• Kruti Kansara

  Hall of Fame

  Points: 3118

  More actions

  April 6, 2009 at 1:24 am

  #972320

  Cant you use DTS wizard?

  "Don't limit your challenges, challenge your limits"

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  April 6, 2009 at 1:58 pm

  #972875

  Hi

  Have a look to BOL for "bcp utility" this should be your solution.

  Greets

  Flo