Article ID: 955713 - Last Review: June 18, 2009 - Revision: 3.0

The ActiveX Script task in an Integration Services package does not run after you uninstall SQL Server 2005 from a computer that has SQL Server 2008 installed

View products that this article applies to.

System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

SYMPTOMS

After you uninstall Microsoft SQL Server 2005 from a computer that has Microsoft SQL Server 2008 installed, the Microsoft ActiveX Script task in a SQL Server Integration Services package does not run. Additionally, when you try to add an ActiveX Script Task to a new package in BIDS, the task will show a validation error pointing ScriptHost can’t be instantiated.

Back to the top

CAUSE

This problem occurs because the Axscphst.dll file is deleted or is unregistered after you uninstall SQL Server 2005. The Axscphst.dll file is in the following location:

%SystemRoot0%\Program Files\Microsoft SQL Server\100\COM

Note SQL Server 2005 and SQL Server 2008 use the Axscphst.dll file.

Back to the top

WORKAROUND

To work around this problem, use SQL Server 2008 Setup to repair the SQL Server 2008 installation.

Back to the top

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.

Back to the top

MORE INFORMATION

Steps to reproduce the problem

Install SQL Server 2005 and SQL Server 2008 on the same computer by using side-by-side installation.
Uninstall SQL Server 2005.
Run the ActiveX Script task in an Integration Services package. Or, run an Integration Services package that has the ActiveX Script task.

Back to the top

REFERENCES

For more information about the ActiveX Script task in SQL Server 2008, visit the following Microsoft Web site:

http://technet.microsoft.com/en-us/library/ms137525(SQL.100).aspx (http://technet.microsoft.com/en-us/library/ms137525(SQL.100).aspx)

For more information about how to upgrade to SQL Server 2008, visit the following Microsoft Developer Network (MSDN)Web site:

http://msdn.microsoft.com/en-us/library/ms144267(SQL.100).aspx (http://msdn.microsoft.com/en-us/library/ms144267(SQL.100).aspx)

For more information about an issue with an Integration Services package in SQL Server 2008, click the following article number to view the article in the Microsoft Knowledge Base:

955645 (http://support.microsoft.com/kb/955645/ ) Error message when you try to run an Integration Services package in SQL Server 2008 on an IA-64-based computer: "Error 0x3: Script Task 1: There was an exception while loading Script Task"

Back to the top