Stop Powershell from opening when running SSIS package

Question

Stop Powershell from opening when running SSIS package

Manny 151

Hi

I am using PowerShell to automate some file work in SSIS. When I run the task in SSIS it runs fine but for a brief second I see the Powershell window open and close very quickly. Is there a way to stop that from happening? The script I have is below:

Get-ChildItem 'C:\Users\Me\ZipFolder' -Filter *.zip | 
    Expand-Archive -DestinationPath 'C:\Users\Me\Temp_Files' -Force

Thank you

Answer 1

Rich Matheisen 36,331

I suppose that would depend on how SSIS runs your script. If they launch Powershell they can use the "-WindowStyle Hidden" parameter, but that's on SSIS.

Manny 151

Thank you @Rich Matheisen

I am not sure how to use it. I think I am doing it wrong. I am getting an error:

     Get-ChildItem 'C:\Users\Me\ZipFolder' -Filter *.zip |   
         Expand-Archive -DestinationPath 'C:\Users\Me\Temp_Files' -Force -WindowStyle Hidden

error:

Expand-Archive : A parameter cannot be found that matches parameter name 'WindowStyle'.  
At C:\Users\Me\UnZipFilesScript.ps1:2 char:103  
+ ... Me\Temp_Files' -Force -WindowStyle Hidden  
+                                                       ~~~~~~~~~~~~  
    + CategoryInfo          : InvalidArgument: (:) [Expand-Archive], ParameterBindingException  
    + FullyQualifiedErrorId : NamedParameterNotFound,Expand-Archive

Rich Matheisen 36,331 Reputation points

2022-01-31T15:24:11.607+00:00

The problem isn't the script that PowerShell runs, it's the way that PowerShell is launched. The "WindowStyle" parameter belongs in the PowerShell.exe command line.
Manny 151 Reputation points

2022-01-31T16:07:48.327+00:00

Thank you for the clarification @Rich Matheisen .

I ran this in SSIS and the window still appears:

-F C:\Users\Me\Documents\SSIS\UnZipFilesScript.ps1 -WindowStyle Hidden

Any suggestions on how to fix the window issue?
Rich Matheisen 36,331 Reputation points

2022-01-31T16:23:17.407+00:00
It's not a parameter for your script, it's a parameter for PowerShell.exe: about_powershell_exe

PowerShell.exe -NoLogo -WindowStyle Hidden -File C:\Users\Me\Documents\SSIS\UnZipFilesScript.ps1
Manny 151 Reputation points

2022-01-31T16:33:09.453+00:00

Hi @Rich Matheisen
SSIS won't let me enter anything after the PowerShell.exe. There is a browse option there to find the exe file and that is it. The only location where I can enter anything is the location where I enter the script.
Rich Matheisen 36,331 Reputation points

2022-01-31T19:46:26.787+00:00

I don't have any SQL servers to try anything with. But this link (execute-powershell-script-from-ssis-package) looks to me as if you can run a process and supply commandline arguments.

Stop Powershell from opening when running SSIS package

1 answer

Activity