Home Forums SQL Server 2005 SQL Server 2005 Integration Services Data conversion in SSIS RE: Data conversion in SSIS
Ray M
SSC-Insane
Points: 21093
More actions
December 10, 2012 at 8:23 am
#1567064
I think all you need to do is add a space between your date and time.
(DT_DBTIMESTAMP)(SUBSTRING(EVENT_D,7,4) + "-" + SUBSTRING(EVENT_D,4,2) + "-" + SUBSTRING(EVENT_D,1,2) + " " + EVENT_T)