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 Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
kshah82
New Member
New Member

--
20 Apr 2006 11:55 AM
Hi,

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?

Thanks
You are not authorized to post a reply.

Acceptable Use Policy