Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Cannot edit SSIS Script Task in SQL Server BIDS 2008

 
   Database Help (Home) -> DTS RSS
Next:  Select only some records or everything in a store..  
Author Message
Roberto

External


Since: May 16, 2008
Posts: 7



(Msg. 1) Posted: Thu Oct 29, 2009 4:53 pm
Post subject: Cannot edit SSIS Script Task in SQL Server BIDS 2008
Archived from groups: microsoft>public>sqlserver>dts (more info?)

I have a SSIS package with Script Task created in SQL Server BIDS 2008 . When
I open the Script Task Editor and click on the 'Edit Script' button. I get a
following error message. I uninstalled and installed again as whole SQL
Server 2008 as shared features. Nothing changed.

===================================

Cannot show Visual Studio 2008 Tools for Applications editor. (Microsoft
Visual Studio)

===================================

The VSTA designer failed to load:
"System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM
class factory for component with CLSID {7525139F-BB6B-447A-A81E-360B2197C3B2}
failed due to the following error: 80040154.
at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.EnsureDTEObject()"
(Microsoft.SqlServer.VSTAScriptingLib)

------------------------------
Program Location:

at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.EnsureDTEObject()
at
Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.InitNewScript(String
languageID, String projectname, String projectext, Boolean bCleanupOnClose)
at
Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.InitNewScript(String
languageID, String projectname, String projectext)
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskUI.ShowIDE()

 >> Stay informed about: Cannot edit SSIS Script Task in SQL Server BIDS 2008 
Back to top
Login to vote
JohnBarryAtUconn

External


Since: Oct 30, 2009
Posts: 1



(Msg. 2) Posted: Fri Oct 30, 2009 6:33 am
Post subject: RE: Cannot edit SSIS Script Task in SQL Server BIDS 2008 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Have you intsalled Microsoft Visual Studio 2008 SP1 (Service Pack)?

"Roberto" wrote:

> I have a SSIS package with Script Task created in SQL Server BIDS 2008 . When
> I open the Script Task Editor and click on the 'Edit Script' button. I get a
> following error message. I uninstalled and installed again as whole SQL
> Server 2008 as shared features. Nothing changed.
>
> ===================================
>
> Cannot show Visual Studio 2008 Tools for Applications editor. (Microsoft
> Visual Studio)
>
> ===================================
>
> The VSTA designer failed to load:
> "System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM
> class factory for component with CLSID {7525139F-BB6B-447A-A81E-360B2197C3B2}
> failed due to the following error: 80040154.
> at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.EnsureDTEObject()"
> (Microsoft.SqlServer.VSTAScriptingLib)
>
> ------------------------------
> Program Location:
>
> at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.EnsureDTEObject()
> at
> Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.InitNewScript(String
> languageID, String projectname, String projectext, Boolean bCleanupOnClose)
> at
> Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.InitNewScript(String
> languageID, String projectname, String projectext)
> at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskUI.ShowIDE()
>
>

 >> Stay informed about: Cannot edit SSIS Script Task in SQL Server BIDS 2008 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SSIS: Blank FolderBrowserDialog in VB.NET Script Task - Hello all, Is anyone having problems with the FolderBrowserDialog being blank in a script task? Please see my thread in ms.pub.dotnet.languages.vb for more info:..

USING VBA from an MS Access module in SSIS (Script Task) - I have an "Execute SQL Task" that has hard coded values like: SELECT CLSD_FL FROM "AMS_FINUSER"."R_APD" WHERE FY = '2010' AND PER = '4' FY = Fiscal Year (Oct-Sep) and PER = Fiscal Month (January) Both FY and PER can be de...

how to cast object type to string type in SSIS's Script Task - Hi, Any idea on casting the Object type to String type in ScriptTask's Design Script area. Thank you in advance. Daniel.

how to troublshoot smtp send mail SSIS task - I have a simple SSIS package that runs a sql query that exports to a flat file, then emails this flat file to an address. I built the package in Visual Studio 2005, where the package runs without a problem. I save the package out to a sql 2005 sp2..

EXEC Stored Procedure does not work in SSIS task - Hi, I have a SSIS package In my source "data flow" task I have a stored procedure (sp_GetTrafficData) which gets the data and populates the table in the destination task. The stored procedure sp_GetTrafficData executes another stored procedur...
   Database Help (Home) -> DTS All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]