SQL 2008: agent job error in opening excel files using DTS package
Have you granted the account Domain\SQL2008S1_service admin rights to the server SQL2000S2?  You will need to do so in order to use the C$ network share.