Random ODBC Errors AND SSIS Errors Saying Sheets doesn't Exist

senpnathan

Hi There



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

 

Thanks

Senthil

Shaine Greenwood

Hi Senthil,

Please reach out to our Support team to troubleshoot this issue.

Thanks!

senpnathan

Thanks Shaine, I thought it was one off but i regularly get this error. Will Raise with the support team.

Thanks

Senthik

senpnathan

Shaine,



I have got any reply from them, do you have any of their support staffs email id please so I can email them directly.



This being a pain now.

Many Thanks

Senthil