You have a few options,

1) define a seperate transformation for that column. DTS has a builtin datetime transformation task.

2) perform an ActiveXScript transformation for that column. This would be necessary if data conversion doesn't work with the previous method.

3) import the data into a staging table, with the date as text. Then run a stored procedure to insert data into the final table doing conversions as necessary.

Keep in mind that either of the first two options will perform the data conversion on a row-by-row basis. This can have an impact on the data import performance if you have a lot of data to import.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface