DTS to SSIS 2008

  • 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

  • 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 .

  • 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