I am trying to import tables from DB2 using DTS into SQLServer 2000. DB2 tables have a default value of "0001-01-01" which SQL Server (DTS) does not like giving invalid date error message. I have no control over the creation of the DB2 tables. Is there a way to handle this issue in DTS. I do not want to import date as varchar as I want to use date functions. These tables are huge.
Does anyone have a solution to help me?