Hi;

My string problem with DTS has been solved.

A colleague suggested that I add a search item to my search string.

If LEFT(field,1) <> "(" then
DTSdestination("myColumn") = CDate(DTSSource("column1")
End IF.

I had several records in my text file with varing numbers of trailing spaces
i.e. "(Null) " a string with the value of "(Null) " in a date field.

By searching for the first parenthesis I could then eliminate that record.

It's the little things.

--
Gordon