Are you executing it from BIDS or scheduling to run it?. Have you looked at package properties to change options to save passwords in the package.