Error System.Exception 'SheetName' object not found.
Action:
Package works fine in development, but after being deployed the following error message is encountered:
Error Message:
“Load L-Table from Excel:Error: System.Exception: 'SheetName' object not found.at CozyRoc.SqlServer.SSIS.ExcelConnection.GetSheetIndex(String #=z$2F$ZhpMEtUi) at CozyRoc.SqlServer.SSIS.ExcelSource.PreExecute() at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100wrapper)”.
Solution:
Check to see if the user account used to execute the package under SQL Job agent has permissions to access the input Excel file.
Book a Presales Call
Related Articles
How to dynamically set the ExcelFilePath when looping through different excel files in a data flow.
Scenario: I have many Excel files with a same format to convert to text files, and I have created a ForEach Loop to loop through each Excel file to have a data flow with an excel source to flat file. Question: How can I dynamically set the ...Error Message: "Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\Windows\TEMP\...' could not be found error CS2008: No inputs specified"
Action: When running an SSIS package under the SQL Job Agent, the following error is encountered. Error Message: "Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\Windows\TEMP\...' could not be found error ...Where can I find the documentation for the Excel Source?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Excel Source can be found at the following link. For many of the components you can find resources ...Error Message: Delegate token node not found.
Action: When using the Dynamics CRM source from the CozyRoc CRM connection manager, the following error message is received. The connection tests successfully and viewing data through the data flow task is possible, but it failed with the error ...Where can I find the documentation for the Excel Connection?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Excel Connection can be found at the following link. For many of the components you can find ...