Importing text files | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Importing text files

I am trying to import a date field from a flat file into a table and can’t seem to get it to work. The table I’ve tried using the DateTime String Transformation function but continue to get the following error. Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Error Description: The number of failing rows exceeds the maximum specified.
Try to import all the rows to a table by defining varchar and
SELECT * FROM myTable WHERE IsNumeric(datefield) <> 1 to show the troubled rows.
Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.