how to stop command prompt window from appearing when running PowerShell script?

Question

how to stop command prompt window from appearing when running PowerShell script?

water490

SSC Eights!

Points: 972
More actions
November 25, 2024 at 5:43 am

#4488636

Hi everyone
I have a PowerShell script that is run by Execute Process Task in SSIS. Each time I run the task I get a black windows prompt screen appearing. Is it possible to hide that? I found one solution online saying to change WindowStyle option in Execute Process Task to hidden but that doesn't work. The black window still appears.
Thank you

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246987 More actions · Answer 1

This is nothing to worry about. After deploying your package to a server, no one will be there to see the dialog box during execution.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

water490 SSC Eights! Points: 972 More actions · Answer 2

I actually run the SSIS package within VS so I can monitor it for any issues so I am watching those black screens pop up.

Phil Parkin SSC Guru Points: 246987 More actions · Answer 3

I don't think there's a way to hide it, so you might have to tolerate it. Or embark on a rewrite.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

dale_berta Ten Centuries Points: 1329 More actions · Answer 4

How are you specifying to run PowerShell, as a scripting task? Spitballing here, but could you run it as an Execute Process Task, with powershell.exe as the executable? Then in arguments, "-WindowStyle hidden".