PowerShell command not executed?

Question

In the following PowerShell v2.0 script, the command & is not executed :

$SqlPackageExe = "C:\Program Files (x86)\Microsoft SQL Server\120\DAC\bin\sqlpackage.exe"
Write-Host "Before SqlPackage"
& "$SqlPackageExe" /Action:Publish $SqlPackageParameters
Write-Host "After SqlPackage"

On the console output, I see : Before SqlPackage After SqlPackage

I have no error, no log, nothing of the SqlPackage.exe. What's happen ? My command "& "$SqlPackageExe" /Action:Publish $SqlPackageParameters" works a first time, a second time (database is deployed), and then stops working. If I close the PowerShell session and open a new PowerShell session, the command works several times, then stops working.

Thank you for your help

This answer stackoverflow.com/a/31351075/9976 has a script that logs output - will help you debug. — Mark
– Mark, Commented Jul 13, 2015 at 1:33

Community · Accepted Answer · 2017-05-23 12:23:56Z

1

You need to redirect StdError and StdOut, see the answer that discusses " -RedirectStandardError -RedirectStandardOutput":

Powershell: Capture program stdout and stderr to separate variables

edited May 23, 2017 at 12:23

CommunityBot

11 silver badge

answered Jul 10, 2015 at 9:10

Ed Elliott

6,88420 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Phil Over a year ago

Ok. I could get an error number. It's a known bug in PowerShell when there are too many Console.Write() : support.microsoft.com/en-us/kb/2701373 Thank you for your help.

Collectives™ on Stack Overflow

PowerShell command not executed?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related