Error System.Exception 'SheetName' object not found.

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+.