Export SQL 2000 DTS, Security profiles and Server Agent Jobs to SQL 2008
I am in need of a method to export or create file to transfer all DTS files, Jobs and Security permissions from our older SQL 2000 server into the new SQL 2008 server. Is there an app within either SQL to perform this? Or a commercial app that you cannot promote in this venue? At present I have scheduled to backup each Database Container through the Management Job into the SQL 2008 Backup folder.