Hello there, I have another request.
First of all I wanna tell you that I´m native german speaking so excuse my bad English spelling. Second I´m programming newbie.
I need the following done!
We want to migrate a sql7.0 cluster to a new sql2000 cluster.
Of course all the DTS Packages and the Stored Procedures and the Jobs should be migrated
With full funktionalibility!
There my problem begins: I have DTS Tasks wich take date from access tables or excel tables or flat files the import and export. Also I have jobs doing the same thing. And finally the Stored Procedurs.
If we migrate the new SQL2000 cluster can´t have the same name as the old one! ;-)
Is there a way how I can retrieve a list where all off the paths are listed, refered by either
DTS or Job or SP???
Thx for any advise
Andreas
First of all I wanna tell you that I´m native german speaking so excuse my bad English spelling. Second I´m programming newbie.
I need the following done!
We want to migrate a sql7.0 cluster to a new sql2000 cluster.
Of course all the DTS Packages and the Stored Procedures and the Jobs should be migrated
With full funktionalibility!
There my problem begins: I have DTS Tasks wich take date from access tables or excel tables or flat files the import and export. Also I have jobs doing the same thing. And finally the Stored Procedurs.
If we migrate the new SQL2000 cluster can´t have the same name as the old one! ;-)
Is there a way how I can retrieve a list where all off the paths are listed, refered by either
DTS or Job or SP???
Thx for any advise
Andreas