Problem connecting to Integration Services

Question

Post reply

Problem connecting to Integration Services

richard-630966

Valued Member

Points: 74
More actions
February 21, 2008 at 6:16 am

#127985

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)

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Deepak-405225 SSCertifiable Points: 6120 More actions · Answer 1

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]

richard-630966 Valued Member Points: 74 More actions · Answer 2

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

richard-630966 Valued Member Points: 74 More actions · Answer 3

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

Johan Bijnens SSC Guru Points: 135256 More actions · Answer 4

- 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

richard-630966 Valued Member Points: 74 More actions · Answer 5

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

frantel90 Newbie Points: 7 More actions · Answer 6

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.