May 28, 2008 at 6:45 am
I have a package that works fine when I execute the package from within Visual Studio. But, when I try to schedule the package with SQL Server Agent, I receive the following error message:
Executed as user: BURUSTADATAMART\sqladmin. ...042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:54:09 PM Error: 2008-05-01 14:54:09.92 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2008-05-01 14:54:28.76 Code: 0xC0202009 Source: USTA_TSR_CUS_ACTIVITY Connection manager "TIMSS Server.USTA.ustaquerro" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Login timeout expired". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x8... The package execution fa... The step failed.
I have tried modifying the Protection Level on the package, yet I get the same error message.
Any ideas what the issue could be?
Thanks,
Bob
May 28, 2008 at 8:26 am
Your error is further down. You need to log the package errors using SSIS logging, but you have a timeout happening in one of your connections. If you turn on logging, you should be able to figure out which connection more easily.
May 28, 2008 at 10:14 am
Thanks for the tip. In looking at the log, I am now seeing the following error message:
"The version of component "Flat File Source" (1) is not compatible with this version of the DataFlow."
How do I check the versions of the components to correct this issue?
May 25, 2009 at 10:49 am
Help me, please
DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Login timeout expired". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "TCP Provider: No such host is known.
My package is runing in Host P1 but in Host P2 not run
Jose Luis :w00t:
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply