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


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.".

enter image description here

asked on Stack Overflow Aug 13, 2020 by Bala Murali • edited Aug 13, 2020 by Bala Murali

0 Answers

Nobody has answered this question yet.

User contributions licensed under CC BY-SA 3.0