Don't know if you done your migration already, but I found this article to be very helpful:

http://www.dell.com/downloads/global/solutions/public/white_papers/sql2005_upgrade_wp.pdf

hope it helps.

I'm not sure if you asking for the role of a SQL Server DBA, but if you are:

The Database Administrator (DBA) who is like the super-user of the system. The...

I agree with Mr or Mrs 500....I am currently in the process of upgrading 2 of my SQL Server 2000 to 2005 and do now which to move over obsolete...

Thank you all for your valuable comments - greatly appreciated.

Instead of copying your package to a local computer you can also run this job from the network drive, however, a network user would need to be created.... the network...