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


7 comments:

  1. Replies
    1. A IEEE project is an interrelated arrangement of exercises, having a positive beginning and end point and bringing about an interesting result in Engineering Colleges for a particular asset assignment working under a triple limitation - time, cost and execution. Final Year Project Domains for CSE In Engineering Colleges, final year IEEE Project Management requires the utilization of abilities and information to arrange, plan, plan, direct, control, screen, and assess a final year project for cse. The utilization of Project Management to accomplish authoritative objectives has expanded quickly and many engineering colleges have reacted with final year IEEE projects Project Centers in Chennai for CSE to help students in learning these remarkable abilities.



      Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
      Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai

      Delete
  2. This comment has been removed by the author.

    ReplyDelete