Loading the data
HI
I am trying to load falt file data in to sql server using SSIS, one of the column has a dates and null values in it in the form of DDMMYYY. i am trying to convert it the form of YYYY-MM_DD HR:MM:SS using Derived column, can anyone help me in
writing the expression for loading the string into that date type.
June 27th, 2012 5:44am
you can try
(DT_DBDATE)(SUBSTRING(date_field,1,2)
+ "-"
+
SUBSTRING(date_field,3,2)
+ "-"
+
SUBSTRING(date_field,5,2))
regards
joon
Free Windows Admin Tool Kit Click here and download it now
June 27th, 2012 8:04am
Hi JOON,
Thax for your Help.
Kind reagards
Ravilla
June 27th, 2012 8:46am