Home Forums SQL Server 2005 SQL Server 2005 Integration Services format the output column in destination .csv RE: format the output column in destination .csv

  • July 23, 2014 at 7:52 am

    #1731759

    Lempster (7/22/2014)

    You shouldn't need a Derived Column transformation to do this. If you click on 'Advanced' in your Flat File Connection Manager Editor, what DataType is the receiving column set to? It should be DT_STR and the OutputColumnWidth property should be set to 11.

    Regards

    Lempster

    I did that but in preview I can still see the leading 00000

    And also the 00000 appear in the .csv file in column AsOfDate.

    Any suggestions?

    Thanks