Solutions:
- using the configuration file, put the information such as password in a configuration file, run the package when read from the configuration file (the configuration file is best stored in a safe place) to replace the ProtectionLevel that package EncryptSensitiveWithPassword and set the password, open CommandLines after deployment, will be prompted for a password, after input, run the package successfully. After deployment, enter DataSource, check the required DataSource, and then enter CommandLines. The previously selected DataSource will be automatically generated in it, and Password will be edited into it.
The first is a formal approach, good security, but more troublesome, because to deploy to a remote server, but do not have the authority to put configuration files into this server, so temporarily unable to adopt this approach.
The latter two are gradually tried out by myself. They are simple and not safe (especially the third one).
Reproduced in: https://www.cnblogs.com/Muller/archive/2012/02/16/2354377.html
Read More:
- Description: Failed to decrypt protected XML node “DTS:Password” with error 0x8009000B “Key not valid for use in specified state
- MySQL error — multiple methods of failed to find valid data directory and MySQL setting password appear
- After node.js is installed, use the instruction node version in vscode to show that it is not an external or internal instruction. The solution is as follows:
- SSH Login: RSA host key for 192.168.x.x has changed and you have requested strict checking. Host key
- Git still needs to enter the user name and password after configuring the public key
- How to Disable Protected View in Microsoft Excel
- Solve the error “unable to perform operation, unexpected error (0x65b)” when inputting powercfg / h off in CMD
- MySql 8.x java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed
- Unable to load file D:: program files (x86) node-v16.4.0-win-x861 because scripts are not allowed to run on this system.
- MySQL 8 — error in setting simple password error 1819 (HY000): your password does not satisfy the current policy requirements
- VUEJS Failed to execute ‘removeChild’ on ‘Node’: The node to be removed is not a child of
- react Error: Objects are not valid as a React child (found: object with keys {username, password})
- CentOS 7 installation error: Cannot find a valid baseurl for repo: base/7/x86_6
- Centos7 forgot the root password and could not log in to the system
- Error: permission denied (public key, GSSAPI keyex, GSSAPI with MIC, password)
- Uncaught TypeError: Failed to execute ‘removeChild’ on ‘Node’: parameter 1 is not of type ‘Node’.
- Uncaught TypeError: Failed to execute ‘appendChild’ on ‘Node’: parameter 1 is not of type ‘Node How to Fix
- install sql server 2016 Error code 0x84B20001
- Remote part of refspec is not a valid name in
- MySQL — initialize failed to generate temporary password in error log after initialization