Hi guys, I am puzzled here, as really don`t know what could be the problem
I have ODBC driver installed on a SQL server and SSIS package pulling data, writing it into SQL table.
Schedule is set to trigger every 1hr
Since few days I see the SSIS job fails, sometimes it runs fine
Error I am getting is
ERROR [S1000] [NetSuite][ODBC 32bit driver][OpenAccess SDK SQL Engine]Failed to retrieve data. Error ticket# xyzxyzxyzxyzxyzxyzxyz[401]
After that I have several consecutive errors (refering to other SSIS stages of the workflow) naming specific tables in NS schema
Can you please help ?
Thanks