Never mind the post above, I had to enable named pipes in the SQL Server Configuration Manager.

Also, I noticed that I get a duplicate key error with named server instances...

Hi David,

I'm receiving the following error when running the checkout package on some of our SQL Server 2000 instances:

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection...