1. kevinwu New Member

   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.
   
   
   
   

   kevinwu, Oct 20, 2004

   #2
2. satya Moderator

   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.

   satya, Oct 21, 2004

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in