Yup, you need a full version (workgroup, std, ent or dev) of SQL Server as SSIS is a component, same as RS, NS and AS.

I confess I don't really understand what you're doing, but it seems to me you are looking for a third party driver to export data from SQL 2005, which has...

On those specs, yes, but you should test it against an eval copy to see the modifications you'll need to make to your connection strings and queries (if any).

You can upgrade directly from SQL 7.0 SP 4 and SQL 2000, there is no need for an intermediary step.

Does it fail with the same COM+ message?

Oooh, handbags at fifty paces! You asked a question, I gave you the right answer.

CCHSD - City of Chicago Health and Safety Department?

I assume you mean you also changed domains in the migration.

You want your maintenace jobs to be owned by sysadmins and run...

SSL encryption or IPSEC, depending on the environment.

If I can assume you have XP clients and a 2003 server, you can set IPSEC which will also protect against man in...

Okay, just to define terms, 'Live' means an integral part of a live service, 'Development' is seperate and has no direct relation to the live servers.

"The server was built to...

No one mentioned SAN yet; this is an active/active cluster, so your binaries/OS should go on a local mirror, the data files on the SAN.

It's unlikely you'll hit any I/O...

Well I like to secure SQL as much as the next guy, but I don't think you are approaching this the right way.

First off, if this is a live server...

That's a good idea, I used to work with MSIs and the last thing you want is your client making network traffic everytime they open an app.

Oh, and is this really on SQL 2005?

Is log shipping functioning? Are backups being dumped to the Log Shipping Destination, and are they being uploaded by the standby server?

You should not be trying to perform manual...

I see no image, could you type the text of it?