Hi Ray M,

As to ans your concern, there will be no invalid dates in the EVENT_D text field as up till now. Assurance are made at client side(presentation layer).

Haha i know it may be simple, but i am too noob:(

I shall do one step by a time. Lets say now i want to convert my EVENT_D and EVENT_T field to date and time field in SSIS, how shall i do it?

NOTE: EVENT_D values in source are in : DD/MM/YYYY format (02/05/2012 to be read as 2nd May 2012)

EVENT_T values in source are in : HH:MM:SS format eg. 22:10:07

My question:

I do know there is a data conversion in SSIS. I should be using that first right?(in between my source and destination). My concern is which data type should i choose? and will the converted values stayed as what it meant? DD/MM/YYYY and HH:MM:SS?

Please guide me:)

Thanks.