Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
SheetNames appear differently in SSIS compared to SmartSheet
I am trying pull the information from Smartsheet Dynamically using SSIS. I see that the Sheet Names in SmarSheet is different to what I see from SSIS ODBC Source.
For Example :
Names in SmartSheet Displayed Name in SSIS
- 801 Centre Road 801 Centre Road__8524479023343492s_(Home)
- Canterbury Road Canterbury Road__4221359879415684s_(Home)
- Burke Road Construction Programme Rev. 6 Burke Road Construction Programme Rev_ 6__490216562681732s_(Home)
Is there a way to find the exact sheet names as in SmartSheet?
If not will the names be displayed same as above SSIS across all users? Why I ask this is if I change the user name in the ODBC source connection for Smarsheet in future SSIS and if the names are shown differently in SSIS for these sheets then the SSIS would fail to pull the data as it would say that the mentioned Sheet is not present in Smartsheets.
Alternatively could we access the metadata of the sheets, may by an admin to see what exact sheet name is stored there?