I'm getting the following error from SQL Agent Jobs history for a package that runs perfectly within SSIS. This package is a near copy of another that uses then same connection managers and runs in SQL Agent with no errors. Both packages were created by the same admin user.
Package Copy is a copy of Package which has been set up as a scheduled job and runs fine. Package Copy (a copy of Package contained in the same project with some changes) refuses to execute from with SQL Agent but runs with no errors with SSIS. Both have the setting encryptsensitivewithuserkey. If I change the username to one which has a blank password then the step works fine so the problem must be the storage and retrieval of the password. But why does Package work and continue to work even if I make changes to it.
Source: Package Copy Connection manager "titan.zhgwebwg.zenweb" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Communication link failure". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Desc... The package execution fa... The step failed.