Include semicolon part of password in ssis config file

1

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

xml
ssis
semicolon
asked on Stack Overflow Sep 6, 2018 by user2431858 • edited Sep 7, 2018 by user2431858

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0