I am having a problem importing a CSV file via DTS into a SQL 2005 table. IT seems SQL does not like null dates as the import blows up when it reaches a null date. I even entered data manually into a few rows then exported it to a CSV file - it exported in the exact format that I had used for the import. I then tried to import the export file created but to no avail. CAN YOU HELP?
Rick

This should be posted in a sql fourm

On your export why don't you do something like:

SELECT
   ISNULL(entryDate, '01/01/1900') as entryDate
From
  [Table]

Hth

"The one language all programmers understand is profanity."