sql server - PowerShell DTexec /ISServer pass a connectionstring as package variable -


i want execute ssis package on isserver via powershell. used script found on microsoft page. doesn't work out me. want pass connectionstring not assign connectionmanager variable string. in connectionstring there \ , ; present , powershell sees new option. want seen whole string.

i've tried everything, adding "\" , \"" websites suggested, used instead of \, put double quotes, put ' quotes, nothing works. getting error optionmyserver\myserver;initial not valid. can't removemyserver\myserver` because connection instance.

the connectionstring assigned via changing variable. variable contains data source=myserver\myserver;initial catalog=sql_myarchive;provider=sqlncli11;integrated security=sspi;

dtexec /isserver  "\ssisdb\test\test.dtsx" /server "myserver" /envreference 8 /par "$package::connectionsource";`""data source=myserver\myserver;initial catalog=sql_myarchive;provider=sqlncli11;integrated security=sspi;"`" 

how can let system see whole connectionstring string? "" , "" not work.

use following syntax pass connectionstring variable (you missed \")

/par "$package::connectionsource";\""data source=myserver\myserver;initial catalog=sql_myarchive;provider=sqlncli11.1;integrated security=sspi;"\" 

Comments

Popular posts from this blog

php - Permission denied. Laravel linux server -

google bigquery - Delta between query execution time and Java query call to finish -

python - Pandas two dataframes multiplication? -