/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

Message
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.


Solution:


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

4 comments:

  1. kalyaniSeptember 4, 2020 at 4:01 AM


    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

    ReplyDelete
  2. pinkyDecember 10, 2020 at 6:53 AM

    I am thankful to you for sharing this plethora of useful information. I found this resource utmost beneficial for me. Thanks a lot for hard work. sviluppo siti web

    ReplyDelete
  3. Muhammad HassanMarch 9, 2021 at 9:00 AM

    Very informative post! There is a lot of information here that can help any business get started with a successful social networking campaign. visit here

    ReplyDelete
  4. Keerthi55September 1, 2021 at 11:26 PM

    sql server dba online training
    sql server dba training

    ReplyDelete

Subscribe to: Post Comments (Atom)