SQL Server Agent does not allow to set parameters for a SSIS package

Question

My SQL Server version is 2012.

I have an SSIS package that is registered in a SQL Server. I have created a SQL Server Agent Job to run my SSIS package.

The SSIS has parameters. So, I thought that a parameter may be set in SQL Server Agent Job GUI:

SQL Management Studio -> SQL Server Agent -> Jobs -> My Job -> Job Set properties -> configuration.
I see that a Parameters tab does exist, but it is disabled and displays nothing, whereas my SSIS has several parameters. See the screenshot attached.

How can I fix this problem?

Answer 1

Hi @Victor Sotnikov ,

Please first have a double check that the package has parameter.

I tested locally that if the package do not have parameter, we could not use the parameter.

Secondly, please have a check if you have the full permission to modify Integration Services packages.

Details you may refer to integration-services-roles-ssis-service.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.