Smartsheet Live Data Connector ODBC issue with SSIS package

David Lam
David Lam
edited 04/02/20 in API & Developers


I installed and configured both the 32 and 64 bit of the Live Data Connector on my machine and created a SSIS package to read from a Smartsheet and write to a SQL Server table. The ODBC connection is made via an access token and my own credentials (we use SSO to log in). From my local machine, the package runs just fine. When I deploy the package to SQL Server and run it, I get the error in the picture.

What I have done:

1) Changed to 32 bit run time

2) Set up a proxy account using my own credentials and having SQL Server Agent run using proxy

3) Installed the LDC for Smartsheet on the SQL Server

My best guess is it has to do with the access token and the proxy account not being able to log into Smartsheet with it. Any suggestions?