You can try the below mentioned code through SSIS package with Active X Script task

Function Main()

Dim Excel_app

Dim ExcelCode

Set Excel_app = CreateObject("Excel.Application")

set ExcelCode = Excel_app.workbooks.open("\\mrtb03.dr.snfores.com\tb\prodSCD\XXX\INFXXSUS\XXX_CVR_CS\Template\VBACode.xls")

Excel_app.Run "Start"

...

Hi Guys,

I got the answer for this issue.

We need to execute the script with domain user (WITH EXECUTE AS 'DOMAIN\USERNAME')

Also we need to grant permission to the domain...

Hi Pradeep,

Thank you for your reply.

I have a batch file (batch.dat) which will connect to sql server and truncates a table.

If i copy the batch file into...