Management Studio exception when expanding SSIS MSDB Stored Pkgs
- From: SAinCA <SAinCA@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 16 Jun 2006 16:47:01 -0700
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?ProdName=Microsoft+SQL+Server&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?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object
connectionInfo, Request request)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList
nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery,
Boolean registerBuilder, Boolean registerBuiltItems)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList
nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider
filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(INodeInformation
source, INavigableItem sourceItem, IFilterProvider filter)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren()
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SummaryView.get_Items()
at
Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage.CopyItems(ISummaryView summaryView)
at
Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage..ctor(ISummaryView summaryView, List`1 columnDescriptors)
at
Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.RightPaneListViewer.PopulateView()
===================================
Specified method is not supported. (Microsoft.SqlServer.ManagedDTS)
------------------------------
Program Location:
at
Microsoft.SqlServer.Dts.Runtime.Application.GetDtsServerPackageInfos(String
sPackageFolder, String sServerName)
at Microsoft.SqlServer.Dts.SmoEnum.PackageEnum.GetData(EnumResult erParent)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req,
Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object
connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object
connectionInfo, Request request)
.
- Prev by Date: Nested packages not firing events when executed via .NET interop
- Next by Date: Re: Date Trouble
- Previous by thread: Nested packages not firing events when executed via .NET interop
- Next by thread: Re: Date Trouble
- Index(es):
Relevant Pages
|
