SQL Server Performance

Importing text files

Discussion in 'SQL Server DTS-Related Questions' started by kevinwu, Oct 20, 2004.

  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.

  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
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page