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.
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.
Adding "\" did the trick so the value of variable looks like \\ServerName\\MainFolder\\InputFiles
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
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
ReplyDeleteVery informative post! There is a lot of information here that can help any business get started with a successful social networking campaign. visit here
ReplyDeleteWhere 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
ReplyDeleteIt 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
ReplyDeleteA 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
ReplyDeletenice blog...........!
ReplyDeleteui path training
google cloud data engineer certification
micro strategy certification training
nice thanks for sharing.................!
ReplyDeletemsbi course training
ui path training
ReplyDeletegoogle cloud data engineer certification
micro strategy certification training
nice information .....!
ReplyDeletemsbi course training
MSBI Certification Training
ReplyDelete