I have the following code in one of Script task in an SSIS.
Dim objexcel As Object
objexcel = CreateObject("Excel.Application")
objexcel.Visible = False
I am getting the error "ActiveX Component cant create object" in production box.
The server is installed with MSExcel, so thats not a problem. And I have another SSIS package running for an year in the same server with the same task to create an excel file(code is same).Folder permissions are also seems to be similar as we replicated the same permission properties from the other application.