Dear folks,
I’ve moved my server folder which contains about 10 dtsx and its ADO .net connection as well as OLEDB into my folder workstation. Then, when I’m gonna to open them appears this error:
Error1Error loading M_HAC_Modelo198_CECA.dtsx: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Clave no válida para utilizar en el estado especificado.". 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.c:\ssis\hacienda_anual\M_HAC_Modelo198_CECA.dtsx11
Translate into english: "Clave no válida para utilizar en el estado especificado" = Invalid key for to use in the specified state (more or less)
What really happen? Well, I wrote these packages using a domain user (belong to Administrators group in Active Directory) via Terminal Server and now I want to modify them by mean my domain user (I already have got installed sql25k client tools and the stuff required)
I thouht that these connections were saved in the same folder where dtsx, dtsproj, etc..
Solution? Create them again? I hope that it will be a piece of cake otherwise...
Thanks in advance for any though or advice,
Well, it really occurs with a only dtsx. Issue raises with a SSIS packages which it was a importation of a sql2k dts. So that it's add a little bit of confusion. Others ones are fine.
No comments:
Post a Comment