• What I would try is put the "max error count" in the Options tab of the properties task doing the import to a certain number e.g. 10.

    Then in the properties of the DTS package on the Logging tab enter a name for an error file.

    When a row fails that row will be put in the error file.

    To check whether any rows do come through you should put the max error count to a number higher than the number of rows in the table. I don't know the upper limit for this parameter though.

     

    good luck,

     

    fred