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.
--Jeff Moden
Change is inevitable... Change for the better is not.