above assembly is not installed on server. also there is no MS EXCEL installed on server.
Then you don't get it working.
The .NET InterOp is a COM wrapper, with utilize the COM interface of Excel, so Excel & the InterOp are mandatory.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
hi
i am using script task to changed sheet name in excel file.
its working fine in my local machine
i am adding following reference in my task.
using Microsoft.Office.Interpro.Excel
using System.Collections.Generic
i did check with DBA , above assembly is not installed on server. also there is no MS EXCEL installed on server.
i am getting error when i schedule job on server . its throwing exception error.
what need to install on server .
anyone knows
above assembly is not installed on server. also there is no MS EXCEL installed on server.
Then you don't get it working.
The .NET InterOp is a COM wrapper, with utilize the COM interface of Excel, so Excel & the InterOp are mandatory.
you mean download on server where sql agent job runs.
can you tell me which location it should be placed.
Hi @coool sweet ,
You need to download the following assembly: Microsoft.Office.Interop.Excel.dll
Download link: microsoft.office.interop.excel-dll