script task exception error

Question

coool sweet 61

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

Viorel 126.8K Reputation points

2022-02-05T04:02:54.57+00:00

I do not think that it will work without Excel; it is not enough to have the Interop assemblies. In addition, if the job works as a service, then check these cautions too: https://support.microsoft.com/en-us/topic/considerations-for-server-side-automation-of-office-48bcfe93-8a89-47f1-0bce-017433ad79e2.

Maybe there are some other kinds of jobs or libraries that do not require the presence of Excel application to modify Excel files.
CarrinWu-MSFT 6,891 Reputation points

2022-02-07T07:13:55.653+00:00

Hi @coool sweet , thank you for your post. Did below answers help you? If yes, could you please do "Accept Answer"? If no, could you please provide the original error message?

3 answers

Viorel 126.8K Reputation points

2022-02-05T04:02:54.57+00:00

I do not think that it will work without Excel; it is not enough to have the Interop assemblies. In addition, if the job works as a service, then check these cautions too: https://support.microsoft.com/en-us/topic/considerations-for-server-side-automation-of-office-48bcfe93-8a89-47f1-0bce-017433ad79e2.

Maybe there are some other kinds of jobs or libraries that do not require the presence of Excel application to modify Excel files.
CarrinWu-MSFT 6,891 Reputation points

2022-02-07T07:13:55.653+00:00

Hi @coool sweet , thank you for your post. Did below answers help you? If yes, could you please do "Accept Answer"? If no, could you please provide the original error message?

Answer 1

Yitzhak Khabinsky 27,096

You need to download the following assembly: Microsoft.Office.Interop.Excel.dll
Download link: microsoft.office.interop.excel-dll

Answer 2

Olaf Helper 47,616

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.

Answer 3

coool sweet 61

you mean download on server where sql agent job runs.
can you tell me which location it should be placed.