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 |
|
varalakshmi
Yak Posting Veteran
98 Posts |
 Posted - 2010-09-08 : 09:33:05
|
| Hi,I've to load date values to a flat file destination.When loaded, the dates are in the format 1/1/2010.But I have to load it in the format 01/01/2010.Please let me know how this could be achieved..Thanks in advance.- Varalakshmi. |
|
|
varalakshmi
Yak Posting Veteran
98 Posts |
Posted - 2010-09-09 : 02:01:34
|
| Hi, I got the desired output with the following expression in the Derived Column Transformation.(DT_STR,10,1252)(((MONTH(DATE) < 10 ? "0" + (DT_STR,1,1252)MONTH(DATE) : (DT_Str,2,1252)MONTH(DATE))) + "/" + ((DAY(DATE) < 10 ? "0" + (DT_STR,1,1252)DAY(DATE) : (DT_Str,2,1252)DAY(DATE))) + "/" + (DT_Str,4,1252)YEAR(DATE))-Varalakshmi. |
 |
|
|
|
|
|
|
|
SSIS date format