October 26, 2011 at 8:03 am
my ssis packages are working fine in BIDS
my data source is oracle.//destination is sql serve(native)
when i scheduled the packages with sql a job
they fails
i used proxy also.
i set excution options use 32bit runtime
how handle these scheduling& configuration issues when connecting to oracle server.
errors are
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: 2011-10-26 16:22:00.80 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: 2011-10-26 16:22:01.35 Code: 0xC0202009 Source: Package Connection manager "TRNG.apps" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value<c/> if available. No work was done.". End Error Error: 2011-10-26 16:22:01.35 Code: 0xC020801C Source: Data Flow Task OLE DB Source [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "TRNG.apps" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2011-10-26 16:22:01.35 Code: 0xC0047017 Source: Data Flow Task SSIS.Pipeline Description: component "OLE DB Source" (1) failed validation and returned error code 0xC020801C. End Error Error: 2011-10-26 16:22:01.35 Code: 0xC004700C Source: Data Flow Task SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2011-10-26 16:22:01.35 Code: 0xC0024107 Source: Data Flow Task Description: There were errors during task validation. End Error
October 26, 2011 at 10:39 am
Your issue is with the encryption setting for your package. Open your package in BIDS and go to Properties -> Protection Level. Odds are you have it set to EncryptSensitiveWithUserKey. You need to change that and probably the best way is to use EncryptSensitiveWithPassword. Check out BOL here
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply