/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

10 comments:

  1. 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
  2. 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
  3. Where to get quotes and what's in store At the hour of this composition, trader account statement sites work utilizing one of two plans of action to shape their administration offering. Each kind of administration has its upsides and downsides - it's dependent upon you to conclude which type best meets your requirements. funny quotes photography

    ReplyDelete
  4. It is the kind of information I have been trying to find. Thank you for writing this information. It has proved utmost beneficial for me. Oprah Winfrey quotes

    ReplyDelete
  5. A great content material as well as great layout. Your website deserves all of the positive feedback it’s been getting. I will be back soon for further quality contents. Jeff Bezos quotes

    ReplyDelete