Search code examples
variablesssisenumerationbackslashforeach-loop-container

SSIS is doubling up backslashes

I am loading some file names and locations as variables into SSIS, then tried using foreach loop to execute a process task.

after a few unsuccessful attempts I realized SSIS is doubling up all the Backslashes in the fields I am loading into my variables. hence the network addresses not working.

can we stop this behavior?

What I load: 

"\\BBBB001\shared\GGGG\PiMSSSRSReportsPath\THM022\HHHH-NextWorkingDay-at1530.pdf"

What I get: 

"\\\\BBBB001\\shared\\GGGG\\PiMSSSRSReportsPath\\THM022\\HHHH-NextWorkingDay-at1530.pdf"

SSIS Execute Process task:
enter image description here

as you can see foxit reader doesn't recognize the later filename with double backslashes. if I manually inter the first value it will work.

Solution

  • For future reference, I found a workaround:

    Instead of adding variables in Arguments section, I created a single variable including all the parameters for the file to be printed. something like this:

     /t "FileLocation\FileName.pdf" PrinterName

    And then put this variable in the expression section of the Execute process task, add argument and put that final variable in front it. like this:

    enter image description here