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


5 comments:

  1. sandeep saxenaJune 10, 2019 at 4:22 AM

    This blog was making more interesting. Keep adding more information on your page.

    C C++ Training in Chennai
    JMeter Training in Chennai
    JMeter Training
    learn JMeter
    JMeter Training Course
    Appium Training in Chennai
    javascript training in chennai
    core java training in chennai

    ReplyDelete
  2. velrajJune 24, 2019 at 6:30 AM

    The innovative thinking of you in this blog. This blog makes me very useful to learn.
    Selenium Training in Chennai
    Selenium Training
    selenium classes in chennai
    Selenium Course in Chennai
    Selenium Training in Annanagar
    Selenium training in vadapalani
    Digital Marketing Course in Chennai
    Python Training in Chennai
    Big data training in chennai
    JAVA Training in Chennai

    ReplyDelete
  3. cynthiawilliamsJuly 20, 2019 at 4:53 AM

    I really admired your post, such great and useful information that you have mentioned here.
    Ethical Hacking course in Chennai
    Ethical Hacking Training in Chennai
    Hacking course in Chennai
    ccna course in Chennai
    Salesforce Training in Chennai
    AngularJS Training in Chennai
    PHP Training in Chennai
    Ethical Hacking course in Tambaram
    Ethical Hacking course in Velachery
    Ethical Hacking course in T Nagar

    ReplyDelete
  4. vincentomoloAugust 9, 2019 at 11:56 AM

    This comment has been removed by the author.

    ReplyDelete
  5. BalaAugust 28, 2019 at 10:40 PM

    Really superb post, I got a lot of things from your valuable post and Well do...
    Pega Training in Chennai
    Pega Course
    Primavera Training in Chennai
    Tableau Training in Chennai
    Unix Training in Chennai
    Job Openings in Chennai
    Placement Training in Chennai
    Linux Training in Chennai
    JMeter Training in Chennai
    Pega Training in T Nagar
    Pega Training in Anna Nagar

    ReplyDelete

Subscribe to: Post Comments (Atom)