You said you are using SQL Server credentials to login. But with this setting unless you provide the password with external configuration file, the connection will not work.
You said you already had this package working from another machine. Do you use exactly same user account on both machines?
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/