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

Post a Comment

Popular posts from this blog

cookies - Yii2 Advanced - Share session between frontend and mainsite (duplicate of frontend for www) -

i have custom members system have made: yii2 members system . can refer full details, or install can work question. i have frontend , backend yii2 provides, few modifications separate sessions/cookies backend works admin model , pulls admin table. similar old traditional member systems. mainsite clone of frontend , it's role main website. when go www.site.com or site.com . here 3 apps , example domains: mainsite = www.site.com or site.com frontend = users.site.com backend = admin.site.com when user logs in ( users.site.com/site/login ) , go homepage ( mainsite @ www.site.com ) want know logged in , show username. how frontend operates default advanced app. from have far, login , head mainsite , reads an internal server error occurred. . doesn't yii error, server error? when in yii logs under runtime, mentions access control: 2017-04-14 13:38:25 [127.0.0.1][1][-][error][yii\web\httpexception:403] exception 'yii\web\forbiddenhttpexception'...
Read more

angular - password and confirm password field validation angular2 reactive forms -

i need check whether password , confirm password fields have same value using reactive form angular2. did see lot of answers on same here, angular 2 form validating repeat password , comparing fields in validator angular2 , none seemed work me.can please help."this" undefined in validate function :( . sharing code, this.addedituserform = this.builder.group({ firstname: ['', validators.required], lastname: ['', validators.required], title: ['', validators.required], email: ['', validators.required], password: ['', validators.required], confirmpass: ['', [validators.required, this.validatepasswordconfirmation]] }); validatepasswordconfirmation(group: formgroup): any{ let valid = true; // if (this.addedituserform.controls.password != this.addedituserform.controls.confirmpass) { // valid = false; // this.add...
Read more

javascript - Angular2 intelliJ config error.. Cannot find module '@angular/core' -

Image
i new angular2. following tutorial angular2 example . first simple tutorial called guess-the-number i used code described in github provided example https://github.com/chandermani/angular2byexample/tree/master/guessthenumber . it loads fine in browser. intellij setup i'm having issues. intellij returning following error.. seen in screenshot. cannot find module '@angular/core' my properties file follows systemjs.config.js system.config({ map : { 'app': 'app', 'rxjs': 'https://unpkg.com/rxjs@5.0.0-beta.12', '@angular/common': 'https://unpkg.com/@angular/common@2.0.0', '@angular/compiler': 'https://unpkg.com/@angular/compiler@2.0.0', '@angular/core': 'https://unpkg.com/@angular/core@2.0.0', '@angular/platform-browser': 'https://unpkg.com/@angular/platform-browser@2.0.0', '@angular/platform-browser-dynamic': 'https://unpkg.c...
Read more