Hi ravikumar Can you elaborate on "some of the parameters are pass environments while executing time like in DEV or QA or PROD." please?Arthur My Blog

hi Guys, I have ssis package in ssis 2005. i upgraded that ssis 2005 package into 2012. here my doubt is in my previous version of ssis package calling some Stored procedures. after upgrading into 2012 how to pass those sp parameters in 2012 by using parametrs tab in 2012. and some of the parameters are pass environments while executing time like in DEV or QA or PROD. please any one guide me with example. regards, ravikumar.

Hi Arthur, Here my problem was, I have two packages 2005. One is master and another is child package. I created config file for those two packages and executed in 2005 successfully. Now i upgraded to 2012 i can't get the config file and same as confusing on parameters tab. In general parameters tab when we used , when the package is executing from different servers like DEV,QA or PROD right. but here i am not able to get the project parameters even i upgraded to project deployment. Can you please clarify me , if you understand my problem. Thanks, Ravikumar

Hello, Check out the link below. It may help you. http://www.simple-talk.com/sql/ssis/working-with-variables-in-sql-server-integration-services/ http://www.bidn.com/blogs/DustinRyan/bidn-blog/2610/upgrade-2005-2008-ssis-packages-to-2012-like-a-boss http://sqlschoolgr.wordpress.com/2012/01/04/5-tips-for-a-smooth-ssis-upgrade-to-sql-server-2012/

Hi Arthur, Here my problem was, I have two packages 2005. One is master and another is child package. I created config file for those two packages and executed in 2005 successfully. Now i upgraded to 2012 i can't get the config file and same as confusing on parameters tab. In general parameters tab when we used , when the package is executing from different servers like DEV,QA or PROD right. but here i am not able to get the project parameters even i upgraded to project deployment. Can you please clarify me , if you understand my problem. Thanks, Ravikumar A parameter may be project wide in SSIS 2012, yoou just need to set it up so, what remains unclear is " i can't get the config file" what does mean? Does it mean you do not have the menu item to set / modify it?Arthur My Blog