Smartsheet Live Data Connector ODBC issue with SSIS package
Greetings,
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?
Answers
-
Hi @David Lam,
If you're not already, I'd recommend working with our Support team on this so they can effectively troubleshoot this behavior with you.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives