How to Use DTS to Export a Table to a text file?

• jw8

  Valued Member

  Points: 58

  More actions

  October 23, 2003 at 7:55 am

  #107219

  Hi,

  How to Use DTS to Export a Table to a text file? what are the steps? I also would like to format and convert data during the process, for example: Convert integer such as 1 to "01" and convert datatime to a format of "YYMMDD" etc.

  Thanks

• philcart

  SSC-Forever

  Points: 47794

  More actions

  October 23, 2003 at 5:23 pm

  #479385

  Take a look at the Tutorial section over at http://www.sqldts.com

  http://www.sqldts.com/default.aspx?107

  Hope this helps

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface

• Teague

  Grasshopper

  Points: 10

  More actions

  October 24, 2003 at 7:37 am

  #479463

  Check out REPLICATE to pad with leading zeros:

  select replicate('0', N - datalength(cast (X as varchar (N)))) +

  cast (X as varchar (N))

  from, YYY

  N = length of string

  X = name of column being converted

  YYY = table name