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 21, 2014 at 9:03 am

    #1731051

    Jeff Moden (7/21/2014)

    arkiboys (7/21/2014)

    Hello,

    in ssis, I use a oledb source to execute a stored procedure and a flat file source to have the result into .csv format file.

    One of the result columns is Date.

    The stored procedure returns dd/mm/yyyy but when I look at the .csv destination file, it shows the column as dd/mm/yyyy 00:00:00

    Question:

    How do I get rid of the 0's after the date in the destination .csv file please?

    Lookup the CONVERT function in Books On Line. That'll do it for you.

    This is the sql I am using in stored proc:

    AsOfDate = convert(varchar(11),AsOfDate,103)

    It returns something like dd/mm/yyyy but in th edestination .csv I get dd/mm/yyyy 00:00:0000

    I tried using derived column but that doe snot seem to do it.

    Any suggestions please?

    Thanks