Sorry for the delay. I've been meaning to update you. After banging my head on the wall for weeks on this I noticed that there is a command...

On the server, right? I have a call in to the server admin.

Can...

Didnt work. I'm trying a bunch of combos with no luck.

ServerB account is not a windows account but...

Failed also when using dtexec.

I use win auth to log in (does that mean its on a domain?) but I was able to login to SSMS also with this account.

I didnt think I could run a package using dtutil. It looks like it's just for copying/moving etc. on the local server? Just so you know I'm working...

Yes it runs error-free in BIDS.

I added the decrypt option but it doesnt seem to save it because I close it, run it, it fails, I go back in and it's not there. Also...

So I changed the protection level of the package to "EncryptAllWithPassword" and entered a password and it ran successfully in BIDS. But of course failed with the same error...

I changed the password but same result. I have that login set up as a user in the msdb in the target database. Any certain roles or securable...

I saved it to the file system.

I just discovered, though, that the connection manager is failing in BIDS with the same login error. Sorry about that, I'm...

Thanks for the replies. I changed it to DontSaveSensitive and got the same result. Do I have to do anything in BIDS other than save the package for...

Thanks, everyone, for the great replies. 

It sounds like I can go ahead and use the DSN and ADP if I like.  I really like being able to store some temp...