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
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
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 ...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 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 ...How can I set the Date Format for dates in the Excel Destination?
Scenario: You have a package with an OLEDB Source and an Excel + Destination. In the source table you have a field that is timestamp [DT_DBTIMESTAMP] column which is getting converted incorrectly to a number like 43951.5869164352 when loaded to ...