I can place the Script Task component on the control flow tab. I then
double-click on the Script Task and it brings up the Script Task Editor. I
select "Script" on the left. So far, no problems. However, as soon as I
press the "Design Script" button, I get the following error:
===================================
Cannot show the editor for this task. (Microsoft Visual Studio)
===================================
Engine returned Unknown Error (Microsoft.VisualBasic.Vsa.DT)
------------------------------
Program Location:
at Microsoft.VisualBasic.Vsa.Dt.VsaIDE.get_ExtensibilityObject()
at Microsoft.SqlServer.VSAHosting.DesignTime.get_ExtensibilityObject()
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskUI.Dispose()
at
Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskMainWnd.Dispose(Boolean
disposing)
at System.ComponentModel.Component.Dispose()
at
Microsoft.DataTransformationServices.Design.DtrPackageDesigner.DoDefaultActionForTask(TaskHost task)
===================================
Interface not registered (Exception from HRESULT: 0x80040155) (Microsoft.Vsa)
------------------------------
Program Location:
at Microsoft.Vsa.IVsaIDE.get_ExtensibilityObject()
at Microsoft.VisualBasic.Vsa.Dt.VsaIDE.get_ExtensibilityObject()
==================================================
The event viewer Application Log contains the following:
Faulting application devenv.exe, version 8.0.50727.762, stamp 45716759,
faulting module kernel32.dll, version 5.1.2600.2945, stamp 44ab9a84, debug?
0, fault address 0x00012a5b.
Business Intelligence Studio, under Help -> About contains the following:
Microsoft Visual Studio 2005
Version 8.0.50727.762 (SP.050727-7600)
Microsoft .NET Framework
Version 2.0.50727
Installed Edition: Professional
Microsoft Visual Basic 2005 77626-009-0000007-41509
Microsoft Visual Basic 2005
Microsoft Visual C# 2005 77626-009-0000007-41509
Microsoft Visual C# 2005
Microsoft Visual C++ 2005 77626-009-0000007-41509
Microsoft Visual C++ 2005
Microsoft Visual J# 2005 77626-009-0000007-41509
Microsoft Visual J# 2005
Microsoft Visual Studio Tools for Office 77626-009-0000007-41509
Microsoft Visual Studio Tools for the Microsoft Office System
Microsoft Visual Web Developer 2005 77626-009-0000007-41509
Microsoft Visual Web Developer 2005
Microsoft Web Application Projects 2005 77626-009-0000007-41509
Microsoft Web Application Projects 2005
Version 8.0.50727.762
Visual Studio 2005 Tools for Office Second Edition 77626-009-0000007-41509
Microsoft Visual Studio 2005 Tools for the 2007 Microsoft Office System
Crystal Reports AAC60-G0CSA4B-V7000AY
Crystal Reports for Visual Studio 2005
Microsoft Visual Studio 2005 Professional Edition - ENU Service Pack 1
(KB926601)
This service pack is for Microsoft Visual Studio 2005 Professional Edition -
ENU.
If you later install a more recent service pack, this service pack will be
uninstalled automatically.
For more information, visit
http://support.microsoft.com/kb/926601 SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 9.00.2047.00
SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 9.00.2047.00
SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 9.00.2047.00
I have uninstalled and reinstalled both Integration Services and Visual
Studio 2005 Professional. However, the error persists.
There is never a time where I can edit a script task and select "Design
Script"
Any ideas? Am I facing a complete wipe of my machine and re-installation of
all of my software?
--
