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?