SSIS Task "Execute SQL" is not in my toolbox. How can I get it?

Question

I see several examples that show how to use the Execute SQL task. One such example I see this screen shot:

There are a lot of tasks there that I don't have in my task list. The one I am looking for is "Execute SQL".

I also note that they don't have "OLE DB Command" (which is what I would usually use to call SQL).

Do I just have a different version? Is "OLE DB Command" the successor to "Execute SQL"? Or is there some way to get the stuff I am missing?

Answer 1

You might be inside a Data Flow - that will only show you items related to a Data Flow (Data Flow Sources, Data Flow Transformations, Data Flow Destinations).

If you are in the Control Flow, and cannot see the items you indicate as missing, you can right click to add.

This will give you a dialog box where you can choose the items that you want to add