January 2, 2012 at 4:29 am
Hi Friends ,
I am just trying to run the package using this T_SQL command line " exec xp_cmdshell 'DTEXEC /FILE "D:\Conversion\GEOConversion\Tipps\Tipps\bin\Package.dtsx" /CHECKPOINTING OFF /REPORTING EWCDI /SET "\Package.Variables[User::JurisID].Value";1356' "
but i am getting error....
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
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D Description: "Login failed for user 'sa'.".
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "LocalHost.Tipps.sa" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Description: component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.
i hope, you guys may ask this question .. i use "encrypt sensitive with user key " property in the package..
Gimme your guidance Friends.
Thanks,
Charmer
January 3, 2012 at 8:40 am
Using that option requires that the same user who last saved the package is the one who runs it. ie: somedomain\myusername last saved the package so somedomain\myusername must be the one to run it..
CEWII
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply