Task: Use the 2005 "Copy Database" function to copy the SQL2000 databases to SQL2005. The ultimate goal is to copy all the live databases from SQL2000 to SQL2005, check everything has upgraded ok, then uninstall SQL2000.

Error #1: First option I tried was "Use the detach and attach method". Using Windows authentication. Selected the databases, tables and object to copy. Create package name. On the "Schedule the Package" screen only option avail is "Run immediately". The "Integration Services Proxy Account" option is greyed. Upon hitting "NEXT>" I get a popup "Proxy account has to be selected to proceed further." That's as far as I can get with this option.

Error #2: Second option I tried was "Use the SQL Management Object method". Using Windows authentication. Selected the databases, tables and object to copy. Create package name. "NEXT>". Immediately at the "Schedule the Package" screen a popup appears: "The specified @subsystem_name ('SSIS') does not exist. (Microsoft SQL Server, Error: 14262)".

Solution:
A common situation more and more are coming across getting aclimated to the *new* sql agent architecture.

you will need to install SQL integration services which may not be installed by default. (you can run the install package again and add it) the service is required to execute the package and the missing / reuired proxy account is created during the Integrtion services installation.