Anyone know how to transfer SQL 2000 jobs to SQL 2005 ?

Anyone know how to transfer SQL 2000 jobs to SQL 2005 ?

 

  


On a 2005 Server not set up by me ... trying to pull in jobs from a 2000
box so I can later put certain jobs back onto it when it is upgraded.

(Upgrade will be to backup everything, detach 2000 user db's, blow away the
2000 install completely, install 2005, attach the user db's)

I am at a stand still:

In ISSI:

Source and Dest. connections defined ok - they test ok.

In Control Flow, have the Transfer Jobs Task defined. Have set all
properties so allow the jobs to transfer.

Job List Property says "(Collection)" and trying to inspect it by clicking
on it brings up a blank Collection Members List.

Trying to add a job gives me the message "Constructor on Type System.String
not found"



======================================================================
Confidentiality Notice: The information contained in and transmitted with this communication is strictly confidential, is intended only for the use of the intended recipient, and is the property of Countrywide Financial Corporation or its affiliates and subsidiaries. If you are not the intended recipient, you are hereby notified that any use of the information contained in or transmitted with the communication or dissemination, distribution, or copying of this communication is strictly prohibited by law. If you have received this communication in error, please immediately return this communication to the sender and delete the original message and any copy of it in your possession.
======================================================================


MS Sql Server LazyDBA home page