Thursday, February 16, 2012

Tip to Change SSIS Variable Scope

Recently I work on a SSIS project that has a Sequence Container with lot of variables that I need for a data flow. Later on I want to change the sequence container to be a For Loop Container.   It is easy to copy and paste the the data flow in the container to the other. But, how to move the SSIS variables in the visual studio?

If you are familiar with the SSIS XML code, you may be able to copy or move the variables from one XML Node section to the other without corrupt it.  For others, recreating the variable with correct value or expression could be cumbersome.

Here is a easy way to handle it:

  • Install BIDS Helper from CodePlex site.
  • Select the variable you want to copy or move

image

  • Click on the Move/Copy Variables from SSIS Variables tool bar to open a new window

image

  • Click on the DTS executable that you want the variable scope to change to , then click OK

image

  • The variable shows up in the SSIS Variables Window with new Scope

2 comments:

  1. There is hardly any people who got this scope to survive with in such a shirt time.Frequently they have this chances to use this in their work and after that they will be the most famous business group in this world.





    Computer Cooling

    ReplyDelete
  2. I visited lot of site and read lot of article. I am really happy for this post in this site. So i always want to concentrate in this site about different article.
    ATX Computer Cases

    ReplyDelete