'Run ssis package with dynamic parameters from stored procedure or Job Agent

I have deployed a SSIS project into my server. There is a master package that should be execute with parameters. The parameters are datetime type.

I need to pass two each parameter the value: of Actual date - 1. I setted up a Sql server job but as i understand i cann pass there only a static value

enter image description here

How can i pass dynamic values to the job? Maybe can i run the package with SP procedure and set the value?

Anyway i will be appreciate if you can write to me an explanation.

sql-serverstored-proceduresssisssmssql-agent-job


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions