February 18, 2008 at 6:10 am
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.
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy