From a SQL Server agent job I execute the following:
"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /FILE "D:\Nickname2\Nickname2\Nickname2.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E
But I get the following error:
Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS
assword" 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: 2013-01-21 14:30:29.00 Code: 0xC0202009 Source: Nickname2 Connection manager "CPICFED.db2admin" 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 ". End Error Error: 20... Process Exit Code 1. The step failed.
I change, or update the password, still error, very fustrated.