I am trying to run SSIS package that is designed by another developer using SQL Server Agent and getting this error: "Package Execution on IS Server failed...". I have a use account with SQL authentication. The package pulls data from another sql instance to which I do not access. Is there a way for the owner of the package to save his windows credentials in the package so I can execute the package? If that is not possible, what is the workaround? Thanks.