I created a package to transfer some tabular data from an Excel sheet into SQL Server 7.0. Everything runs fine except for one field which is an nvarchar field. The values of the field are either null, 'Removed', or a date (stored as a string obviously). When the package is executed, the records that have the date string, are converted to nulls.
Anyone have any ideas on this? Do I need to modify the script to explicitly check for a valid date in the field and do a convert to nvarchar?
Anyone have any ideas on this? Do I need to modify the script to explicitly check for a valid date in the field and do a convert to nvarchar?
