SSIS ActiveX Script Task throw an error at validation
I'm importing a fully functionnal SSIS package from a production server to my development laptop (who have all development environments installed and from which I originally developped the SSIS package). But I have this error when validation all ActiveX task, and I can't find help about this anywhere. can someone help me please? TITLE: Package Validation Error ------------------------------ Package Validation Error ------------------------------ ADDITIONAL INFORMATION: Error at osti [ActiveX Script Task]: User script threw an exception: "An error occurred while creating the ActiveX scripting host. Verify that the scripting host is installed properly.". Error at osti: There were errors during task validation. (Microsoft.DataTransformationServices.VsIntegration) thanks for your time and help
March 28th, 2011 4:28pm

Have you installed the 5.8 version ? http://msdn2.microsoft.com/en-us/library/9bbdkx3k.aspx-------------------------------------- /R.
Free Windows Admin Tool Kit Click here and download it now
March 28th, 2011 4:33pm

One or more libraries are missing, you can try to debug the task as mentioned in this post: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/835edb90-878b-4e95-a51d-a3d42d89aeef/ Once you find the offending component, you may go the server to take it and install on your machine.Arthur My Blog
March 28th, 2011 4:35pm

Have you installed the 5.8 version ? http://msdn2.microsoft.com/en-us/library/9bbdkx3k.aspx -------------------------------------- /R. well, I can't find any links to download this... Anyway, my laptop is a Windows 7 Pro, with SQL Server 2008 R2 Developper and VS 2005/2008/2010 installed, shouldn't it be already installed? And this package was developped on my laptop... So I just can't understand why any Activex Script Task wont work anymore..
Free Windows Admin Tool Kit Click here and download it now
March 28th, 2011 4:45pm

One or more libraries are missing, you can try to debug the task as mentioned in this post: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/835edb90-878b-4e95-a51d-a3d42d89aeef/ Once you find the offending component, you may go the server to take it and install on your machine. Arthur My Blog thanks for the reply. Any ActiveX Script Task fail at validation. I tried a simple: Function Main() MsgBox "hello" End Function and it fail with the same error...
March 28th, 2011 4:46pm

How did you import your package?Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
March 28th, 2011 5:08pm

I imported the .dtsx located on the production server. I tried to create a new package with an ActiveX Script Task. Even with a new package, it fails at validation with the same error.
March 28th, 2011 5:13pm

Something is broken. I would re-install the SSIS at this stage.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
March 28th, 2011 5:19pm

can I reinstall SSIS without uninstalling SQL Server first? Or I have to get rid of everything before?
March 28th, 2011 5:28pm

You can try the repair option, but in some cases a full un-install and a subsequent install works better. Before doing this, you can probably try to export the package to another machine to try if it works there.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
March 28th, 2011 5:34pm

There is unfortunatly no other machine with a licensed MSSQL 2008. I'll try to repair my server and see if it fix the problem
March 28th, 2011 5:37pm

You can try the repair option, but in some cases a full un-install and a subsequent install works better. Before doing this, you can probably try to export the package to another machine to try if it works there. Arthur My Blog I uninstalled the whole thing and re-installed from scratch. It fixed the problem. thanks
Free Windows Admin Tool Kit Click here and download it now
March 28th, 2011 11:06pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics