Using the import facility of the DTS I need to convert
a character field representing a date of format yyyymmdd
into DATETIME. Within the DTS package I`ve tried to add
a SQL step (SET DATEFORMAT YMD) before the transformation
step but this doesn`t help. Do you know a general solution
without converting each DATETIME field of the VBA script?