Search

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

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)
0
User(s) can reproduce this bug
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 (expand)

Product Language

English

Version

SQL Server 2012 - Enterprise Core Edition

Category

Developer Tools (SSDT, BIDS, etc.)

Operating System

Windows 7 Professional (SP1)

Operating System Language

German

Steps to Reproduce

Create a Sequence Container.
Click into the Sequence Container.
Create a Variable.
Look up the scope of the Variable

Actual Results

Scope acutally is the main package

Expected Results

Scope should be the Sequence Container

Platform

X64

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Posted by Whuppi 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.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement