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
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives