locked
SSIS 2008 - Make Selected Items (Boxes) Same Width In Control Flow & Design Flow RRS feed

  • Question

  • In Format tab -> Make Same Size --> Width

    Same size as which box?

    When I resize the top one, select it, and select the others one by one holding down the CTRL key, it does resizes to the top one.

    Wonder if there is a better way....


    Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com
    Friday, October 23, 2009 10:41 PM

Answers

  • Easy:

    1. Size one Task to the size you want it.
    2. Hold down CTRL, and click any other Tasks you want to make the same size.
    3. Select the Format -> Make Same Size -> Width, or whatever option you want.

    The key is that the Format tools work on all "selected" Tasks, and pattern them after the task with the "current" selection - the one with the unfilled square markers, not the filled square markers.
    Todd McDermid's Blog
    • Marked as answer by Kalman Toth Friday, October 23, 2009 11:15 PM
    Friday, October 23, 2009 11:01 PM

All replies

  • Easy:

    1. Size one Task to the size you want it.
    2. Hold down CTRL, and click any other Tasks you want to make the same size.
    3. Select the Format -> Make Same Size -> Width, or whatever option you want.

    The key is that the Format tools work on all "selected" Tasks, and pattern them after the task with the "current" selection - the one with the unfilled square markers, not the filled square markers.
    Todd McDermid's Blog
    • Marked as answer by Kalman Toth Friday, October 23, 2009 11:15 PM
    Friday, October 23, 2009 11:01 PM
  • Thanks Todd. Now I see the unfilled & filled square markers!!!

    Basically it sizes to the first one you select before holding down the CTRL key for more selection.
    Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com
    Saturday, October 24, 2009 12:02 AM
  • One more "deep" question.

    What is the official name of the boxes (shapes) in Control Flow and Data Flow?
    Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com
    Saturday, October 24, 2009 12:22 AM
  • In the Control Flow, they're "Tasks".
    In the Data Flow, they're "Components", or "Transforms".
    Todd McDermid's Blog
    Saturday, October 24, 2009 4:46 AM
  • There are sources and destinations boxes also.

    I meant how do you refer to the "boxes" (graphical objects)?

    In the flowchart I see boxes and pointed connecting lines independently of what they do.

    Wonder if there is official naming?

    Are they shapes? Boxes? Blocks? Rectangles?
    Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com
    Saturday, October 24, 2009 6:54 AM
  • The sources and destinations are "Components" as well.  You can see that by dropping a Script component on the Data Flow - you get the choice of it being a source, transform, or destination.  They're all the same, except some have inputs only, some have outputs only, and some have both.  Just because it's called a "destination" doesn't mean it doesn't have outputs, and just because it has inputs and outputs, doesn't mean it can't write information out (OLE DB Command) or read information in (Lookup).

    You can call them anything you like - they're definitely shapes ;)
    Todd McDermid's Blog
    Saturday, October 24, 2009 7:00 AM
  • Thanks Todd.  I found it. BOL calls them SHAPES:

    "If the shapes in the control and data flow layouts are random sizes, or if the shapes are not aligned or grouped, the functionality of package can be more difficult to understand."

    Also I've seen "data flow objects" as alternate to "data flow components" in BOL.


    Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com
    Saturday, October 24, 2009 7:07 AM
  • Yes - tasks, components, log providers, foreach enumerators - they're all called objects...
    Todd McDermid's Blog
    Saturday, October 24, 2009 7:43 PM
  • Why the heck did it take me this long to find this????
    • Edited by st9912345 Wednesday, March 4, 2020 2:30 AM
    Wednesday, March 4, 2020 2:30 AM