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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics