Hello,
I have a particular SSIS Package that loads data from a Smartsheet into a SQL Server table via an OLE DB Destination component. This is a very standard setup at my org, and this exact package had been chugging along as expected for months until 06/05. Now I’m receiving an error message stating “There is a data source column with no name. Each data source column must have a name”. Can confirm that there is no such “nameless” column in the sheet, nor hidden columns. I’ve tried re-adding the CData connection manager, creating a copy of the Smartsheet, and rebuilding the .sln to no avail. It’s hard to tell at this time whether the issue is Smartsheet or CData, but figured it’d be easier to ask here first. Thanks in advance!
