February 21, 2008 at 6:16 am
Hi,
this one has me stumped. I start SQL Server Management Studio for SQL Server 2005 and instead of connecting to Database Engine I connect to Integration Services. The two options are Running Packages and Stored Packages. Choosing Stored Packages I then click on MSDB and get the attached error. I am trying to convert some old DTS to SSIS. Does anyone know how I find out which version SSIS is trying to reference and how to change it?
Many thanks.
===================================
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()
===================================
Please check the version of the database and instance of the server, which the SSIS service configuration is referencing for storage folders. (MsDtsSrvr)
------------------------------
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)
February 21, 2008 at 8:46 pm
Have you applied SQL Server 2005 Service Pack 2 if not pls go ahead and apply the same and see if the problem persist.
[font="Verdana"]- Deepak[/font]
February 22, 2008 at 3:17 am
OK, thanks, Deepak. I wasn't involved in the setup of the server and there's a few things that don't seem quite right. Right at the moment there's some issues with access, so as soon as I can get back on I will have a look at SPs.
Cheers,
Richard
February 24, 2008 at 12:43 pm
Hi,
OK, SP2 applied and the version number has changed but I still got the same error. Then, by chance, I found - http://forums.microsoft.com/msdn/showpost.aspx?postid=75967&siteid=1 - so I changed the ini file, bounced the server and I can get into SSIS. Not that I know what I'm doing now I'm there
Thanks for you help.
Richard
February 24, 2008 at 1:49 pm
- did you check with sql2005 upgrade advisor ?
Should be your starting point for any preparation towards SQL2005.
- In BI-dev studio (vs2005) if you create a new bi-integration server project,
there is a menu option "migrate sql 2000dts to SSIS"
This is a best effort tool, but you'll still have to check the results.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 25, 2008 at 10:55 am
OK, I shall have a look at both. This is a strange situation where the company's original developer/DBA seems to have left in the middle of the server switch and upgrade. In the absence of anyone else I was asked to help and I'm OK with most things but out of my depth with others.
Cheers,
Richard
September 7, 2016 at 4:31 pm
Hi, if you just want to get packages back you can create a project of type SSIS in BIDS, then you can add existing package to it connecting to any package location.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy