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 option
myserver\myserver;initial not valid. can't remove
myserver\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
Post a Comment