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

  • Pergunta

  • 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
    sexta-feira, 23 de outubro de 2009 22:41

Respostas

  • 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
    • Marcado como Resposta Kalman Toth sexta-feira, 23 de outubro de 2009 23:15
    sexta-feira, 23 de outubro de 2009 23:01

Todas as Respostas

  • 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
    • Marcado como Resposta Kalman Toth sexta-feira, 23 de outubro de 2009 23:15
    sexta-feira, 23 de outubro de 2009 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
    sábado, 24 de outubro de 2009 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
    sábado, 24 de outubro de 2009 00:22
  • In the Control Flow, they're "Tasks".
    In the Data Flow, they're "Components", or "Transforms".
    Todd McDermid's Blog
    sábado, 24 de outubro de 2009 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
    sábado, 24 de outubro de 2009 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
    sábado, 24 de outubro de 2009 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
    sábado, 24 de outubro de 2009 07:07
  • Yes - tasks, components, log providers, foreach enumerators - they're all called objects...
    Todd McDermid's Blog
    sábado, 24 de outubro de 2009 19:43
  • Why the heck did it take me this long to find this????
    • Editado st9912345 quarta-feira, 4 de março de 2020 02:30
    quarta-feira, 4 de março de 2020 02:30