Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Execute SSIS with parameter from stored procedure

Author  Topic 

Shubhanshu
Starting Member

8 Posts

Posted - 2014-08-01 : 10:16:34
Hi
I am little confused about passing parameters to my SSIS package. I have developed a front end which execute a stored procedure . This stored procedure executes JOB and finally job will execute the package .

Now, I have to sent the parameters from front end (year and month) to my package . So if anyone can share their solution for this problem do let me know.

tm
Posting Yak Master

160 Posts

Posted - 2014-08-01 : 11:39:31
Refer to link below to add code to modify the environment variables into your stored procedure is one solution.
This is assuming you are using Project deployment model (SSISDB).

[url]http://stackoverflow.com/questions/17098239/ssis-2012-how-do-i-change-the-projects-environment-variables[/url]
Go to Top of Page
   

- Advertisement -