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

  • Soru

  • 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
    23 Ekim 2009 Cuma 22:41

Yanıtlar

  • 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
    • Yanıt Olarak İşaretleyen Kalman Toth 23 Ekim 2009 Cuma 23:15
    23 Ekim 2009 Cuma 23:01

Tüm Yanıtlar

  • 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
    • Yanıt Olarak İşaretleyen Kalman Toth 23 Ekim 2009 Cuma 23:15
    23 Ekim 2009 Cuma 23:01
  • 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
    24 Ekim 2009 Cumartesi 00:02
  • 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
    24 Ekim 2009 Cumartesi 00:22
  • In the Control Flow, they're "Tasks".
    In the Data Flow, they're "Components", or "Transforms".
    Todd McDermid's Blog
    24 Ekim 2009 Cumartesi 04:46
  • 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
    24 Ekim 2009 Cumartesi 06:54
  • 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
    24 Ekim 2009 Cumartesi 07:00
  • 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
    24 Ekim 2009 Cumartesi 07:07
  • Yes - tasks, components, log providers, foreach enumerators - they're all called objects...
    Todd McDermid's Blog
    24 Ekim 2009 Cumartesi 19:43
  • Why the heck did it take me this long to find this????
    • Düzenleyen st9912345 4 Mart 2020 Çarşamba 02:30
    4 Mart 2020 Çarşamba 02:30