dbTalk Databases Forums  

Management Studio exception when expanding SSIS MSDB Stored Pkgs

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Management Studio exception when expanding SSIS MSDB Stored Pkgs in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
SAinCA
 
Posts: n/a

Default Management Studio exception when expanding SSIS MSDB Stored Pkgs - 06-16-2006 , 06:47 PM






I connected to the Integration Services service. As I'd used the deployment
tools to install a simple package in the DB, which I can see is there from
the stsdtspages90 table, I wanted to run it from the Management Studio.

When I expand the Stored Packages folder, all is well.

When I expand the MSDB folder, the exception occurs. Full technical details
are at the end of this post...

Short Message is:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click:
http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

Specified method is not supported. (Microsoft.SqlServer.ManagedDTS)

************************************************** **********

So I changed the MsDtsServer permissions for my NT Login to be the same as
the Admin Group (of which I AM a member). No joy!

The page cited in the link is useless- no info.

What's up? Is the SMO collection automatically installed?

Configuration is:
.. XP Pro SP2
.. SS2000 SP4
.. SS2005 SP1 + Hotfix = build 9.0.2153
.. NO Analysis Services.
.. All other services installed.

FULL TECHNICAL DETAILS follow:
===================================

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

------------------------------
For help, click:
http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

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

at Microsoft.SqlServer.Management.Smo.Enumerator.Proc ess(Object
connectionInfo, Request request)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.BuildDynamicItem WithQuery(IList
nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery,
Boolean registerBuilder, Boolean registerBuiltItems)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.BuildDynamicItem (IList
nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItemBuilder.Build(INodeInfor mation
source, INavigableItem sourceItem, IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.NavigableItem.GetChildren()
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.SummaryView.get_Items()
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ap pIDPackage.ListViewVirtualStorage.CopyItems(ISumma ryView summaryView)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ap pIDPackage.ListViewVirtualStorage..ctor(ISummaryVi ew summaryView, List`1 columnDescriptors)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ap pIDPackage.RightPaneListViewer.PopulateView()

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

Specified method is not supported. (Microsoft.SqlServer.ManagedDTS)

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

at
Microsoft.SqlServer.Dts.Runtime.Application.GetDts ServerPackageInfos(String
sPackageFolder, String sServerName)
at Microsoft.SqlServer.Dts.SmoEnum.PackageEnum.GetDat a(EnumResult erParent)
at Microsoft.SqlServer.Management.Smo.Environment.Get Data()
at Microsoft.SqlServer.Management.Smo.Environment.Get Data(Request req,
Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetD ata(Object
connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.Enumerator.Proc ess(Object
connectionInfo, Request request)



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.