How to Change Scope of Variable (Move Variable) in SSIS Package - SSIS Tutorial

In SQL Server Integration Services 2008 and previous versions once the variable was created with Scope , it was not possible to change the scope of that variable without deleting and recreating in correct scope.

In SSIS 2012 and latest versions, we can create variables without worrying about scope and then can move them to required scope any time without deleting and recreating.

SSIS 2008, there is no option available to move or change the scope of variable.
Old versions of SSIS , had no option to change scope of variables

SSIS Move Variable Option

Change scope of variable in SSIS Package

In below snapshot we can see that the both variables were created on package level and then by using Move Variable Option we changed the scope for Variable1 from Package to For Loop Container.

How to change Scope of variable in SSIS Package 

Scope Changed from Package to For Loop Container
How to change Scope of variable from Package to Container in SSIS Package


  1. Replies

    1. IEEE Final Year projects Project Center in Chennai are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation. For experts, it's an alternate ball game through and through. Smaller than expected IEEE Final Year project centers ground for all fragments of CSE & IT engineers hoping to assemble. <Final Year Projects for CSE It gives you tips and rules that is progressively critical to consider while choosing any final year project point.

      JavaScript Training in Chennai

      JavaScript Training in Chennai

      The Angular Training covers a wide range of topics including Components, project projects for cseAngular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

  2. This comment has been removed by the author.

  3. Birds aren't always active throughout the day. It is possible to check an area in the morning and see birds all over.  bird watching binoculars

  4. As I said personal taste is important and there will often be disagreements with one user believing that Swarovski are the world's best binoculars while another will swear by Leica (for example) but what the top binoculars have in common i Best binoculars for hunting

  5. python interview questions and answers

    Important Python Interview Questions and Answers for freshers and experienced to get your dream job in Python! 101 Python Basic Interview Questions for Freshers

  6. I really appreciate this wonderful post that you have provided for us. I assure this would be beneficial for most of the people. scope management

  7. It seems you are so busy in last month. The detail you shared about your work and it is really impressive that's why i am waiting for your post because i get the new ideas over here and you really write so well.
    SQL Server DBA Training in Bangalore

  8. This post is so interactive and informative, keep updating more information.
    data science tutorial for beginners
    hacking tutorial

  9. Thanks for this great post! I am using your article for my reference. Keep sharing more such valuable articles.
    HTML5 Training
    HTML Training
    PHP Training in Chennai
    Software Testing Training

  10. I just want to thank you for sharing this post, now I can move the constant variable to Dissertation Help Online easily. Thank you and have a good day.

  11. Great blog. Thanks for sharing such a useful information.
    Java training chennai

  12. This post is so helpfull and informative.keep updating with more information...
    Scope Of German Language
    Benefits of Learning German Language

  13. Thank you for this blog. It is very useful. Share more like this.

    AWS Online Training
    AWS Online Course

  14. This post is so interactive and informative.keep update more information...
    selenium training in tambaram
    selenium training in chennai

  15. A debt of gratitude is in order for the blog entry amigo! Keep them coming... Window replacement

  16. This post is so helpfull and informative.Keep updating with more information...
    IELTS Coaching


  17. Thank you for this great information. It is a very helpful blog. Share More like this
    Tally Course in Chennai
    Online Tally Course

  18. This comment has been removed by the author.

  19. PHP is a programming language that runs on a server and is specifically developed for web development. PHP is a simple language to learn, and the code is well-organized and clear. The programming language PHP is considered to be one of the most secure programming languages accessible, and it is one of the finest alternatives for creating a safe website. If you want to start a career in PHP web development, FITA Academy would be the ideal choice for getting the best PHP Course in Chennai .

    To know more: PHP Training Online |
    PHP Course in Coimbatore

  20. Hi, Great information you will provide thanks for sharing this useful information and content.

    Best IAS Coaching in Delhi

  21. Excellent post, it will be definitely helpful for many people. Keep posting more like this. Embark on your English learning adventure right here in Bahrain with Ziyyara Edutech! Our tailored online English tuition is perfect for beginners seeking to master the language.
    Book a free demo today. Best online english language Class in bahrain