Home Forums Data Warehousing Integration Services SSIS convert to date issue RE: SSIS convert to date issue
quillis131
Hall of Fame
Points: 3706
More actions
January 22, 2013 at 11:00 am
#1579752
Here is expression you needed
(DT_STR,4,1252)YEAR((DT_DBDATE)"January 22, 2008") + "-" + (DT_STR,2,1252)MONTH((DT_DBDATE)"January 22, 2008") + "-" + (DT_STR,2,1252)DAY((DT_DBDATE)"January 22, 2008")