Post reply

Export to CSV with leading zeros

  • 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

  • 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
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply