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 PumpError 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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>