Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
qman
Constraint Violating Yak Guru
442 Posts |
 Posted - 2010-03-30 : 12:14:24
|
| I am trying to run an SSIS Package as a Step to a SQL Job.This SSIS package connects to DB2 tables, reads the data, and populates SQL tables.When this step executes in SQL Server, the following error is generated:"Started: 12:10:33 PMError: 2010-03-30 12:10:33.14 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 ErrorError: 2010-03-30 12:10:35.69 Code: 0xC0202009 Source: get_and_put Connection manager "SOURCE_DB2" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D.An OLE DB record is available. Source: "IBM OLE DB Provider for DB2" Hresult: 0x80040E4D Description: " SQL30082N Attempt to establish connection failed with security reason "3" ("PASSWORD MISSING"). SQLSTATE=08001".................... more available.....I am able to execute the SSIS package directly from within Visual Studio 2005. The error message mentions passord missing. This is not true, it is defined in the SSIS and saved file.The step is defined as a SSIS Type, Run as: SQL Agent Service Account, Package source, File system, Windows Authentication.Package resides on drive on server.Any thoughts? I have played around assigning security directly to the SSIS file. No luck....ThanksQman |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-30 : 13:37:52
|
| change the protection level to "Rely on server storage and roles for access control" |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-30 : 13:44:39
|
| seems like you've used protection level EncryptSensitiveDataWithUserKey which is causing this while executing it from sql job using service account. So change it to as russell suggested------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
qman
Constraint Violating Yak Guru
442 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-31 : 13:50:21
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Problems Running SSIS Package from SQL Job