Importing Blank Dates From .CSV

[Devilboy916]

Hi everyone

I am trying to import a .csv file into a SQL table using DTS.
In this file is a date field with null values.
This is correct data, but when I run the DTS, an error returns saying it cant put text values into a date field.

I have 'allow nulls' ticked on the date field in SQL.

i cant think of what it could be!

Anyone?
Cheers

 

[DataLWalker]

Hi Devilboy916,

When importing from a CSV data source file, DTS assigns a varchar/nvarchar datatype for each column in the CSV file.

You could use a "staging" table in MSSQL to import all the Source CSV data, and then use a Transform Data Task to load data into the Destination table.

In the Transform Data Task set the transformations for each column to your requirement using ActiveX scripts, essentially VBScript, so any VB/VBA data-type conversion function can be used.


HTH,
DataLWalker