Hi friends, I have a stored procedure which takes a input parameter which can be either 'A' or 'B'. Based on the input parameter the stored procedure executes the logic. This stored procedure is used in SSIS package using EXECUTE SQL TASK. Now this package is to deployed at SQL Server. There would be two jobs created and which would be scheduled for each input parameter 'A' and 'B'. Now my query is how can i set the input parameter from the sql server job so that the value can be used in the EXECUTE SQL TASK in the SSIS package.

In SQL Agent execute SSIS package from Step Type Operating System Command and write DTEXEC command to Execute Package and use /SET Option to set SSIS package Variable one similar thread is here or you can use package configurations also. Shailesh , Please mark the post as answered if it answers your question.