Home Dashboard Directory Help
Search

Create a Variable in an SSIS Package using SSDT. Scope is always base package not current container. by Christian Terhart


Status: 

Closed
 as By Design Help for as By Design


4
0
Sign in
to vote
Type: Bug
ID: 770801
Opened: 11/12/2012 5:19:33 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

Hi there,

when you create a variable in an SSIS solution, it is always created in the base scope even when you are currently in another scope.
To move it into the right scope you have to use tools like BIDS Helper.
Details
Sign in to post a comment.
Posted by NilsRottgardt on 3/20/2013 at 10:18 AM
It is much more work than creating the variable in the scope of the active object like before. Would be nice to get the old behavior back with an option in Data Studio.
Posted by Microsoft on 1/18/2013 at 12:45 AM
Hi, thank you for your feedback. You can change the scope of the variables using the "Move Variable" option in the Variables window.
Sign in to post a workaround.