July 27, 2009 at 7:57 am
Hi,
I have installed a SQL2008 Ent Edition on a test server as a named instance on a server which also has SQL2000 (Win 2003 platform)
I also needed to move a 2000 DTS from another server into the new 2008 instance. I did the following:
Did a save as on 2000 to 2005
Run the 2005 Backward Compatibility Component
Run the DTS Designer component
Stopped\started SQL - No good
Copied 6 DLL files from 80\Binn to 100\Binn as per previous tip - No good
Changed the Env PATH so 80\Binn before 100\Binn as per previous tip - No good
Each tmie I get the msg :
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)
...even though i have dnoe this and stopped\started SQL
Any thoughts please???
Thanks v much
July 27, 2009 at 3:22 pm
Hi,
When you install SQL Server 2008, you also need to install Client Tools Backward Compatibility.
For more information, see the Installing Support for DTS Packages section of "How to: Install Support for Data Transformation Services Packages" at http://msdn.microsoft.com/en-us/library/ms143755.aspx .
July 28, 2009 at 2:14 am
Thanks but thats exactly the procedure I used. As mentioned in the body of my note I did run the Backward Compatibility (BC) msi too, but still no luck?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply