If you are having problems running it from the stored profcedure, but you can run it fine from Query Analyzer, check to see what account your service is logging in as. You may not have access to the DTS file with the account that the service uses.