/REPORTING E " has mismatched quotes. The command line parameters are invalid. The step failed.

I created the SQL Server Agent job to run an SSIS Package. The Package needed to read the file from input folder. As the Package is not created with SSIS Configuration, I had to pass the folder path to variable in SQL Server Agent job.

I provided the value to the variable as shown below and executed the job.
Fig 1: How to pass value to Variable in SQL Server Agent Job for SSIS Package

The job failed with below error

Executed as user: Domain\svsSSISAccount. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    The argument "\Package.Variables[User::FolderPath].Value;\\ServerName\MainFolder\InputFiles" /REPORTING E " has mismatched quotes.  The command line parameters are invalid.  The step failed.


Adding "\" did the trick so the value of variable looks like \\ServerName\\MainFolder\\InputFiles

Fig 2: How to set variables in SQL Server Agent Job for SSIS Package

1 comment:

  1. Through this post, I know that your good knowledge in playing with all the pieces was very helpful. I notify that this is the first place where I find issues I've been searching for. You have a clever yet attractive way of writing on Msbi online training
    Msbi online training Hyderabad
    Msbi online training India
    Msbi online course
    Msbi course
    Msbi training
    Msbi certification training