I have requirement to use automated password generated with semicolon to be used to connect Red shift db through SSIS config file. What are my options to use password with semicolon part of it. The SSIS config file is saved with encrypt with user sensitive. When I am trying to execute ETL through SQL server Agent Job, It gives me following error : 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
What are my options to remove this error and then use password with smeicolon in SSIS config file
User contributions licensed under CC BY-SA 3.0