Execute Process Task quote encloses variables used in expressions - by mfearskp

Status : 


Sign in
to vote
ID 777329 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 1/23/2013 4:35:45 PM
Access Restriction Public


Variables containing quotes in expressions are ultimately wrapped as a literal.

String variable 
-File "C:\Development\KP Integration\KP Integration\ADExport.ps1" "C:\Test\ADUsers.csv"

"C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe" "-File "C:\Test\test.ps1" "C:\argument\path\test.csv"" at "".

Note the " injected before the -File value and at the end of the string.

Cannot use replace function due to dependencies on quotes to pass file path information to PowerShell.
Sign in to post a comment.
Posted by Microsoft on 7/8/2013 at 3:28 PM
Hello Mfearskp. Thanks for the feedback. We triaged this issue and at this time do not plan to address this in a future version of SQL Server. The suggestion will be saved for consideration with future releases.

-Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)