Export to CSV with leading zeros

• Ghanta Bro

  Ten Centuries

  Points: 1079

  More actions

  March 27, 2006 at 9:13 am

  #167534

   

  Hi All,

  Thanks for help...

  I have a DTS package in SQL Server2000 that exports a file in CSV format. One of the columns has to have leading zeroes, which I added in the execute sql; however, when exported, the leading zeroes are not there. What is the easiest way to fix this. I have bunch of packages that I need to do the samething for leading zeroes.

  Thanks a lot for help

• Phil Parkin

  SSC Guru

  Points: 246985

  More actions

  March 27, 2006 at 9:21 am

  #628957

  Please do not cross post. Follow this thread.

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=268690

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel