Not able to Pass Switch Parameter from Command Shell Prompt

Question

I have a PowerShell script which has couple of parameters including a switch parameter.

The below command executed within PowerShell works as expected:

  \\localhost\Test\Code\DataPullResults.ps1 -TestName 'Test survey' -QUser '[email protected]' -SqlServerInstanceName localhost -SqlDatabaseName MyDatabase -Load:$True -ErrorAction Continue;

But when I ran the same command from command prompt I get an error:

\\localhost\Test\Code\DataPullResults.ps1 : Cannot process
argument transformation on parameter 'FullLoad'. Cannot convert value
"System.String" to type "System.Management.Automation.SwitchParameter".
Boolean parameters accept only Boolean values and numbers, such as $True,
$False, 1 or 0.

Below is the command which I have used to execute from the command prompt:

C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe powershell.exe -ExecutionPolicy ByPass -File \\localhost\Test\Code\DataPullResults.ps1 -TestName 'Test survey' -QUser '[email protected]' -SqlServerInstanceName localhost -SqlDatabaseName MyDatabase -Load:$True -ErrorAction Continue;

Here Load is a Switch Parameter.

Community · Accepted Answer · 2017-05-23 12:24:31Z

1

powershell.exe does not fully evaluate script arguments when the -File parameter is used (source). So you should use -command instead:

powershell.exe -Command \\localhost\Test\Code\DataPullResults.ps1 -TestName 'Test survey' -QUser '[email protected]' -SqlServerInstanceName localhost -SqlDatabaseName MyDatabase -Load:$True -ErrorAction Continue;

But beside that, note that you don't have to pass a boolean to a switch value. That means, if you omit -Load, $load will be set to $false. And if you pass -Load (without $true), it will get set to $true.

Aslo, did you noticed, that you are calling powershell.exe twice?

C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe powershell.exe

edited May 23, 2017 at 12:24

CommunityBot

11 silver badge

answered Nov 25, 2016 at 7:23

Martin Brandl

59.4k16 gold badges151 silver badges190 bronze badges

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

4 Comments

Roshan Over a year ago

Yes I have used Posershell.exe twice, Which is working fine for another Scripts.

Roshan Over a year ago

I have tried the -Command Instead of -File, Though getting same error. Any Other help

Martin Brandl Over a year ago

How about omitting the $true value?

Jimadine Over a year ago

I came across this problem and omitting the :$True works. In my case I was including it in a (probably unnecessary) attempt to guard against inadvertently binding the next param name to the switch param's value. A bit like as described at stackoverflow.com/a/8526355/1754517

Collectives™ on Stack Overflow

Not able to Pass Switch Parameter from Command Shell Prompt

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related