This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 38%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
I am trying below code(in .dtsx) :-
Clear-Host
# Define the path to the 32-bit dtexec.exe
$dtexecPath = "C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\dtexec.exe"
# Define the path to the SSIS package (.dtsx file)
$packagePath = "E:\Practice_SSIS\All_Package\Demo\Demo\Demo\Demo\Demo.dtsx"
# Build the command to execute the SSIS package
$command = "& '$dtexecPath' '/FILE $packagePath /SET \Package.Variables[User::Variable1].Properties[Value];"1" /SET \Package.Variables[User::Variable2].Properties[ConnectionString];"Data Source=Demo;Initial Catalog=Demo;Integrated Security=SSPI;Auto Translate=True;" ' "
# Execute the command
Invoke-Expression $command | Out-Null
How can I connect SSMS server with this code it is possible to make connection for one or more server?? Output :-- Initial : The term 'Initial' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
s[ConnectionString];
"Data Source=Demo;Initial Catalog=Demo;Integrated Security=SSPI;Auto Translate=True;"
If you want to define a string within a string, then you have to quote the quotation marks; you can already see it on the syntax higligthning that it is wrong:
$command = "...
I Tried your solution but its not working.
/SET \Package.Connections[ConnectionString].Properties[Value];"Data Source=Demo;Initial Catalog=Demo;Integrated Security=SSPI;"
What can I do for this How to I give that string into a variable.
You still don't quote the quotation mark, as I wrote before.
Hello @Olaf helper,
I am not giving the value in connection manager .
I'm declare a variable in package and their data type is string and this package variable using in connection manager as a expression.
Now I'm running my package through powershell so I was SET the value of variables.
If it is possible can I set the connection string value into the variable.
/SET \Package.Variables[User::Server].Properties[Value];'$connectionString'
like this
Hi @Jerry_2424,
Not familiar with Powershell, you may take a reference to this thread. Regards， Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
Hello @Zoe Hui ,
I want to run my SSIS (.dtsx file) through Powershell and have the package variable values returned by Powershell instead of the configuration file. I can set the value of a package variable but cannot set the DB connection by power shell.I used windows authentication.
Hi @Jerry_2424, Have you check a sample here about running package via powershell? Run an SSIS package with PowerShell
Yes , I am checked everything about this, but I am unable to give string into a variable all working fine but not acceptable the connection string . .