Running a powershell job within a .bat file that run a ssis package

Question

Hi all,
I am very new to powershell and batch file commands.
Having trouble running a powershell job within a .bat file that run a ssis package.
I tried running the command in powershell, it works but having trouble after merging it with .bat file.

Command for the powershell:
$securepw = convertto-securestring -string "hello" -asplaintext -force
$bstr = [System.Runtime.InteropServices.Marshal]::SecureStringToBSTR($securepw)
$pw = [System.Runtime.InteropServices.Marshal]::PtrToStringAuto($bstr)

Flow in .bat file:

1. run powershell command to decrypt the securestring and store in a variable (e.g pw)
2. powershell command to pass variable (pw) back
3. use the value of the variable back to set parameter for the ssis package
4. run the ssis package job

Any help is appreciated!

Answer 1

Hi,

You cannot get the powershell variables in batch but you can get the output of powershell.

$securepw = convertto-securestring -string "hello" -asplaintext -force  
$bstr = [System.Runtime.InteropServices.Marshal]::SecureStringToBSTR($securepw)  
[System.Runtime.InteropServices.Marshal]::PtrToStringAuto($bstr)  

The batch file

FOR /F "DELIMS=" %%G IN ('powershell.exe -ExecutionPolicy Bypass -File C:\temp\pw.ps1') DO SET "pw=%%G"  

https://stackoverflow.com/questions/23618016/use-powershell-variable-in-batch

Best Regards，
Ian Xue

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Don't use a .bat file at all. Put all of the commands in a .ps1 file and have Powershell execute it.

How many lines are in the .bat file? Does it just call an executable and pass it some variables, or does it do something more complex like testing to see if files exist and then use GOTO?

If it's not too big can you share the contents?