Error opening a DTS package using SSMS 2008 R2

Question

Error opening a DTS package using SSMS 2008 R2

Kenneth.Fisher

SSC-Insane

Points: 20396
More actions
February 3, 2012 at 10:54 am

#252307

One of my developers has the SQL 2008 R2 tools installed on his machine and needs to access some legacy DTS packages. We have installed the backwards compatibility components and the DTS components but are still getting the following error:
here were errors loading package "...."
[DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection.
(Microsoft.SqlServer.DtsObjectExplorerUI)
I tried logging in as a sysadmin to the server and received the same error from his box. I can open the package from my machine with no problems.
Thanks for any help
Kenneth
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

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

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

SQLback SSCrazy Points: 2897 More actions · Answer 1

Is your developer's machine 32 bit or 64 bit machine ?

I am not sure if it makes a difference but remember reading some thing about 32 bit and 64 bit machines and backword compatibility.

Kenneth.Fisher SSC-Insane Points: 20396 More actions · Answer 2

Its 32bit.

Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

gajapathy Old Hand Points: 315 More actions · Answer 3

Hi,

Following are the solutions from Microsoft.

http://blogs.msdn.com/b/sqlserverfaq/archive/2009/07/09/error-sql-server-2000-dts-designer-components-are-required-to-edit-dts-packages-install-the-special-web-download-sql-server-2000-dts-designer-components-to-use-this-feature-microsoft-sqlserver-dtsobjectexplorerui-ssms.aspx

http://msdn.microsoft.com/en-us/library/ms143755%28v=SQL.100%29.aspx

Regards

gajapathy Old Hand Points: 315 More actions · Answer 4

Hi,

This one gives the clear picture to resolve this issue.

http://www.bisql.net/2010/11/how-to-edit-dts-packages-in-sql-server-2008-r2/

Regards

Jeff N. Cantwell SSC Journeyman Points: 87 More actions · Answer 5

Did you find a solution for this? I too have installed all components, but am now stuck at this point.

Thanks.