Exception from HRESULT: 0x800A03EC while running through SQL Agent

Question

i have a script task in ssis pacakge. Code of the script task :

          string xlsPath = Dts.Variables["User::FilePath"].Value.ToString();

            Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
            app.Visible = false;
            Microsoft.Office.Interop.Excel.Workbook workbook = app.Workbooks.Open(xlsPath);
            Microsoft.Office.Interop.Excel.Worksheet worksheet = workbook.Worksheets[1];
            int ColumnIndex = 4;
            worksheet.Columns[ColumnIndex].TextToColumns();
            worksheet.Columns[ColumnIndex].NumberFormat = "0";
            workbook.Save();
            workbook.Close();

I am having no problem while running package in VS2015, but when running it through sql agent it is throwing the following error :

Exception from HRESULT: 0x800A03EC.

I am using xls file.

This may be of help to you (https://stackoverflow.com/questions/7099770/hresult-0x800a03ec-on-worksheet-range) — Ryan Wilson, Dec 21 '18 at 14:10
There is probably more to the error message than that. Post all the lines from the message that could possibly be related. — Tab Alleman, Dec 21 '18 at 14:24

score 1 · Accepted Answer · answered Dec 26 '18 at 08:01

You can add try...catch... in your script, to catch the exact error message.

It might be caused by permission issue, the account used in the agent job(SQL Server Agent Service Account by default) doesn't have access to the Excel file.

The solution is to run the package using a Proxy Account, which is given enough permissions.

How to create a Proxy Account and use it to run SSIS package

Exception from HRESULT: 0x800A03EC while running through SQL Agent

1 Answers1