Random ODBC Errors AND SSIS Errors Saying Sheets doesn't Exist
I use Smart Sheet 32 bit ODBC component to connect to SmartSheet and pull data to SQL server. Suddenly I see errors randomly.
There has been a random error appearing each time the SSIS package is run (SSIS package uses ODBC provided by Smarsheet), it is not stable with one sheet missing error.
Each time the package is run it throws a different Error message saying that the different sheet is not present. Not sure if there is some problem with SmartSheet as I saw random messages of shutdown in between, please could you advice...
If you could help us ASAP