May 20, 2009 at 6:26 am
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.
May 20, 2009 at 6:47 am
Resolved by following Method 3 in article http://support.microsoft.com/kb/918760
Still don't know why my first Package works and the second doesn't. They were both created by the same userid!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply