So it's clear.. it has not problem with your config because source connection is working fine.

Open the package and just do the test connection on destination connection manager with your password if you are using sql authendication