Home Dashboard Directory Help
Search

Execute Process Task quote encloses variables used in expressions by mfearskp


Status: 

Closed


1
0
Sign in
to vote
Type: Bug
ID: 777329
Opened: 1/23/2013 4:35:45 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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"

Becomes
"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.
Details
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)
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
Integration Services Project1.zip (restricted) 1/23/2013 -