Install DTS package in sql server 2008 cluster

Giganews Newsgroups
Subject: Install DTS package in sql server 2008 cluster
Posted by:  Amirullail (Amirulla…@discussions.microsoft.com)
Date: Sun, 17 May 2009

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

Replies