November 12, 2010 at 4:13 am
I am trying to open SQL Server 2000 DTS packages in SQL Server 2008 R2 but I keep getting the error below but I have downloaded it and installed it. Can you please tell me how I can resolve it
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)
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.ObjectExplorerUI.LegacyActionBase.CreateLegacyDesigner()
at Microsoft.SqlServer.Dts.ObjectExplorerUI.OpenLegacyPackageAction.Act(INodeInformation nodeInfo)
at Microsoft.SqlServer.Dts.ObjectExplorerUI.DtsServerMenuItem.Invoke(INodeInformation parent, String mode, String assembly, String type)
November 12, 2010 at 4:23 am
You'll need the Backward Compatibility and DTS components installed...
follow here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
download:
SQLServer2005_BC.msi
and
SQLServer2005_DTS.msi
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 12, 2010 at 4:41 am
I have downloaded and installed:
SQLServer2005_BC.msi
and
SQLServer2005_DTS.msi
but I keep getting the same error as above
November 12, 2010 at 4:50 am
Restart SQL Services...then try.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply