>>I want to take data from my FPDos 2.5 app and put it into SQL Server 2000. I have tried using DTS to transfer the data but some of my date fields are empty which gives DTS heartburn even if I tell DTS to make the new 'smalldatetime' column nullable. Is there a way to make DTS allow empty date columns?
>you can still tell DTS to allow it - but if the base sql table still has a constraint of 'not null' - you will still be hosed.
I found a solution to the date field issue. I had to do two things:
1) I had already set up the destination column as NOT NULL with no success. I then changed the SQL column definition to datetime instead of smalldatetime. That allowed me to import empty dates.
2) massage some of the dates in the source table because they had years outside the range allowed for SQL datetime columns. These had resulted from data entry errors even though they were valid for a FPD date field.
I now have my data in SQL. Thanks for the help.
Larry Huisingh
Lockheed Martin Information Technology
Richland WA USA