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

senpnathan · 02/11/18

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

Source Tables are listed in SSIS but no preview.jpg

Shaine Greenwood · 02/12/18

Hi Senthil,

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

Thanks!

senpnathan · 02/15/18

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

Thanks

Senthik

senpnathan · 03/19/18

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

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

Comments

Categories