ETL package that processes every morning through SQL Agent. It has
been running for a month or 2 on this build - I received the following
error this morning:
An OLE DB error has occurred. Error
code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native
Client" Hresult: 0x80004005 Description: "Communication link failure". An OLE
DB record is available. Source: "Microsoft SQL Native Client" Hresult:
0x80004005 Description: "TCP Provider: An existing connection was forcibly
closed by the remote host. ". An OLE DB
record is available. Source: "Microsoft SQL Native Client" Hresult:
0x80004005 Description: "Login failed for user '(null)'. Reason: Not associated
with a trusted SQL Server connection.".
package is trying to pull data from our source (remote) server. After the failure I re-started the SQL job and it processed without any errors,
is a critical process so I need to eliminate any errors - any idea why SSIS would pass a NULL login? There is not enough information in the log for me to deterimine the exact OLEDB Source that is causing the error.
Thanks,
-Evan Black
No comments:
Post a Comment