SQL 2008 failover cluster and DTS

#71

Many thanks Uri, I did it and it is working fine now.

"Uri Dimant" wrote:

Quote:

Piotr
Sorry, I should have mentioned that you need to install DTS 2005 Designers
tool ( for exact name please check on internet)
Once you installed it , you will be able to alter/run packages

"Piotr" <Piotr (AT) discussions (DOT) microsoft.com> wrote in message
news:B4B9A18D-2536-4A04-A92C-936E0CA1509E (AT) microsoft (DOT) com...
Many thanks for your reply

Could you give me more details please? I know one of our developers
already
tried this and import finished successfully. But when she tried to run it
on
management console it just closed. I just wonder what is wrong.

"Uri Dimant" wrote:

Piotr
You will have to save a DTS as a structure file and import it in SS2008.

"Piotr" <Piotr (AT) discussions (DOT) microsoft.com> wrote in message
news:1A107ACD-D4ED-45DB-A984-DC8BC39079C9 (AT) microsoft (DOT) com...
Hi

Could you help me fix following problem please?

I have new SQL Server 2008 fail over cluster and need to migrate system
from
stand alone SQL Server 2000. I had no big issues migrating databases
but
now
found a problem. I need to move DTSs from old server to SQL 2008 fail
over
cluster.

Please advise me what is correct way to do this. As far as I know it is
impossible to use them as cluster resource.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL 2008 failover cluster and DTS

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Re: SQL 2008 failover cluster and DTS - 12-23-2008 , 05:29 AM