Home Forums SQL Server 7,2000 T-SQL Bulk load data conversion error (truncation) for row 1 RE: Bulk load data conversion error (truncation) for row 1

  • I'm guessing that today, you got some data in your upload file/source that is missing. I'd first start checking date fields for missing, null or incorrect syntax.

    Then move onto the numeric fields.

    I know one of the things I always did writing DTS/SSIS was put in checks on my date fields that if they were null, I defaulted to something like '1/1/1970.'