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
ReplyDeleteThrough 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