ETL and Data Integration tools - Modern ETL software for everyone

Hi

I am uploading a csv file which has a date field of “5/24/2009 9:44:53 AM”.

I am using a Date format function of “M/D/YYYY H:N:S TT”, which from the manual is correct. I am setting the date to change to current date on fail.

I do appear to be getting some successes in the file, as well as the following errors. Most are errors.

From the data transformation log, I get an error:

Warning 6/4/2011 5:33:01 PM Transformer: Field [CREATED_ON], Value 5/19/2009 1:24:16 PM replaced with System Date (2009-06-04 17:33:01.372)

Error 6/4/2011 5:33:01 PM 1 Transformer: '5/19/2009 3:11:02 PM' is not a valid date and/or time (format: YYYY-MM-DD HH:NN:SS.ZZZ)

Warning 6/4/2011 5:33:01 PM 1 Transformer: Value Of Field [CREATED_ON] is 5/19/2009 3:11:02 PM. Execution Result of Function 'Date Formats: DD.MM.YYYY

M/D/YYYY HH:NN:SS TT

YYYY-MM-DD HH:NN:SS.ZZZ

' is Failure
Any ideas?

NB, just been using the Joiner on another item and I like this and the reader properties – excellent!

B


Kind regards

You have got two spaces between date and time

Mike

Hi

Have done that; used a replace to capture double spaces before moving them to the date format object as there were some with and some without double spaces – the transformation is now working perfectly - thanks.

BG