• Control-flow works like you probably think it does. You drop tasks on it and then, connect their arrows to control the order and conditions of execution.

    Data-flow, is really the internal data routing of a Data

    Transformation task. Once you have a Data Transformation task in your control flow, then you open it up to go to it's data-flow where you can drop components and then use the arrows to control how the data is piped from component to component. However, If you do not have one of those, then you don't have to worry about it (for this question, anyway).

    ----------

    However, longer term, if you are planning to use SSIS, then you will need to learn all of this. It's a huge and complicated subject, and I strongly recommend that you look around for some books or articles to help you get started with it.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]