I have a SQL Server Agent Job that is running an SSIS package and passing in a project-level parameter. The parameter value I typed in is:
C:\Program Files (x86)\7-Zip\7z.exe
The package was giving me an "invalid characters" error so I added a step in the package to write the parameter value to a table. It came out like this:
C:\Program "Files" (x86)\7-Zip\7z.exe
For further info, when I look up the job's command in msdb.dbo.sysjobsteps, it contains this:
/Par "\"$Project::exe_7zip\"";"\"C:\Program Files (x86)\7-Zip\7z.exe\""
What could be causing this?