Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2014-07-21 : 08:13:56
|
| 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:00Question:How do I get rid of the 0's after the date in the destination .csv file please? |
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2014-07-25 : 08:11:33
|
| Use a derived task.Check this link..[url]http://stackoverflow.com/questions/16732641/ssis-date-in-derived-column-as-yyyy-mm-dd-format[/url] |
 |
|
|
|
|
|
format destination flat file .csv