OLEDB read failed

Tue, 07 Jul 2015 16:42:46 GMT

I'm getting an error when trying to load a certain field that holds dates from one of my tables.

I noticed that the script works fine when I use a limited load, but errors out when I try to load the whole table. I started playing around with the limited load and found that it consistently fails when I try to load more than 113145 lines.

I get the following error:

Script error: QVX_UNKNOWN_ERROR:

OLEDB read failed: SQL SELECT CUTEOMERNBR, ACCTOPENDATE FROM CUSTOMER

If I comment out the ACCTOPENDATE field, it loads fine.

I exported the table to Excel and scrolled down to the 113146 line to look at the ACCTOPENDATE field and the date looks just like every other date above it... no special characters or anything:

Any thoughts? Is there a way I can create a script to skip any individual rows it fails on?

Thanks!

Re: OLEDB read failed

Wed, 08 Jul 2015 22:32:55 GMT

I setup an ODBC connection and tried to load the same data. It fails on the same record but gives me a slightly different message:

Any thoughts?

topic Re: OLEDB read failed in Connectivity & Data Prep

OLEDB read failed

Re: OLEDB read failed