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.
| Author |
Topic |
|
Shubhanshu
Starting Member
8 Posts |
 Posted - 2014-08-01 : 10:16:34
|
| HiI 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] |
 |
|
|
|
|
|
Execute SSIS with parameter from stored procedure