I am trying to import a DB2 table date fields into SQL server and its giving me fits. If the date field has a value of 1/1/0001 ot 000-01-01 in the DB2 table I get an error in the DTS package when I run it that says INVALID data value. I thought I could create a Active X script using VB with a select case to trap the value but I get the error before it works. Any ideas on how to fix? Any help would be greatly appreciated. Thank you.
Ken