SSIS /Password 含有特殊字符 包括" / 怎么处理

Question

dtexec/SQL"\SMARTSolution\PKG_IMPORT_SSIS_PACKAGE"/SERVER"."/USERsa/PASSWORD"Pa12~!@#$%^&*()_"+{}|":<>?[]\;',./"/CHECKPOINTINGOFF/REPORTINGE

password 包含 “ / 怎么处理可以直接运行

Answer 1

Change pwd, don't use sql reserved characters in pwd.

Answer 2

What is the reserved characters in the sql server, you can use any pwd in the sql server.
As you say, I need ask the client not to use character balabala....

Answer 3

Depends on how and where to use pwd. If ssis doesn't like it, the best way is changing it.

Answer 4

dtexec /SQL "\SMARTSolution\PKG_IMPORT_SSIS_PACKAGE" /SERVER "." /USER sa /PASSWORD "Pa12~!@#$%^&*()_"""+{}|""":<>?[]\;',./"/CHECKPOINTINGOFF/REPORTINGE

不是因为/的问题，而是"的问题，将密码中的"替换为"""应该就可以了。

CMD中"的转义方式是替换为3个"