January 16, 2009 at 8:51 pm
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.
The connection "connection1" is not found. This error is thrown by Connections collection when the specific connection element is not found.
Cannot resolve a package path to an object in the package ".Connections1.Properties[ConnectionString]". Verify that the package path is valid.
The package path referenced an object that cannot be found: "\Package.Connections connection1.Properties[ConnectionString]". This occurs when an attempt is made to resolve a package path to an object that cannot be found.
DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "connection1" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
===========================
i am getting the above erros when trying to connect oracle dB.please help me
January 17, 2009 at 10:00 am
How are your data source connections stored? Are you using configuration files? If you are can the package access them on the SQL server running the package?
January 17, 2009 at 10:36 am
i tried both ways. storing inside the package as well as config file.
Will the password show up in the config file? i see the userid in the config file but not the password
January 17, 2009 at 12:05 pm
The password will not show in the config file. You must manually add pwd='password'; to the connection string in the config file. If the package is currently set to use the configuration file this may be your issue.
Are you running the package manually using the DTExecUI or scheduling it with a SQL agent job? In either case you will need to tell DTExecUI or SQL Agent to run the package using the the configuration(s). Take a look at this article it walks you through the process of creating a schedule job to run a package.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply