I am a newbie. I have a situation where I need to open up a package built by my Colleague and when I open the package I get an error
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.
I know that Its because the package properties are to ENCRYPTSENSITIVEWITHUSERKEY ... we need to change the property so that the package developed can be open by others also in order to make any modifications... I have tried changing it to DontsaveSensitivedata.If I do that i need to enter the credentials for the ODBC connections manually eachtime.. is there any workaround
Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…