SSIS flat file output, date format is manipulated
Posted on 2011-02-19
I have a very simple procedure which returns four date fields as YYYY-MM-DD. These date fields in the table are VARCHAR(255), but convert them to come back as YYYY-MM-DD.
I have a simple data flow task in SSIS, procedure output to csv. The format of the date fields in the output file come back manipulated, like this: 5/2/1961
If I open the csv in notepad, it is formatted correctly. It is just in the darned csv, when open in Excel, that the values are re-formatted.
I have to get around this.
I just want SSIS to give me back exactly what I give it, in the procedure output.
Does anybody have any suggestions?