Install DTS package in sql server 2008 cluster

Discussion in 'microsoft.public.sqlserver.clustering' started by Amirullail, May 18, 2009.

  1. Amirullail

    Amirullail Guest

    Hi There
    I want to import my DTS package from sql server 2000 to sql server 2008 with
    cluster.

    I save all the required packages from sql server 2000. Then i go to SQL
    server 2008 management studio, select instance, select management, select
    legacy, select data tranformation service, right click and select import
    package file.

    When i try to import the package, I found error that said to install package
    "SQLServer2005_BC(2).msi"...

    So i download the package...

    But before i want to run the package, is there any special step that i need
    to run, like maybe stop the cluster service or else???

    Then do i need to run this package on BOTH nodes or just at Primary/Active
    nodes?

    TQVM....
     
    Amirullail, May 18, 2009
    #1
    1. Advertisements

  2. Amirullail

    Uri Dimant Guest

    Hi
    No, you do not need to to stop the cluster. Just import and start using. Yes
    , you need to move the package on the passive node as well (make sure if
    you move the data from AS400,that all client access references are defined
    on both nodes)
     
    Uri Dimant, May 18, 2009
    #2
    1. Advertisements

  3. Amirullail

    frankm Guest

    frankm, May 18, 2009
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.