Hi @coool sweet ,
You need to download the following assembly: Microsoft.Office.Interop.Excel.dll
Download link: microsoft.office.interop.excel-dll
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
Hi @coool sweet ,
You need to download the following assembly: Microsoft.Office.Interop.Excel.dll
Download link: microsoft.office.interop.excel-dll
you mean download on server where sql agent job runs.
can you tell me which location it should be placed.
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.