Large CSV file load into SQL Columnstore table Random Error , After restart same SSIS works fine RRS feed

  • Question

  • I had experienced strange error while loading csv file (, separated values) contain ~1.2 million rows into SQL (2016) columnstore table using SSIS package, I got following error rarely ,especially on datetime columns.

    After i simply restarted failed ETl it just works fine. We load same file in different environments and error appears only in one environment on same day. I try to add error output and wait to see for next time, Meanwhile i would like to reach out to experts ask for help, if there is any issue with sql columnstore table or SSIS while loading datatime values.

    But error is while insert data, so it could be more of database side issue.

    PackageName > Sequence Container > DFL Transactions. SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Invalid date format". PackageName > Sequence Container > DFL Transactions. There was an error with DST Transactions.Inputs[OLE DB Destination Input].Columns[Account_FromDate] on DST Transactions.Inputs[OLE DB Destination Input]. The column status returned was: "Conversion failed because the data value overflowed the specified type.".

    ps: Posted same question on satackoverflow as well.

    Thursday, August 13, 2020 8:20 AM

All replies