Importing dates (0001-01-01) from DB2 using DTS

Last Post 20 Apr 2006 11:55 AM by kshah82. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

20 Apr 2006 11:55 AM

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?


Acceptable Use Policy