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

Asked 23/8, 2011 at 23:36 Answered 4/7, 2023 at 10:28

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

Extra Tasks

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?

Weightless answered 23/8, 2011 at 23:36 Comment(1)

can you post up a picture of what you actually have in the Toolbox – Subsocial 23/8, 2011 at 23:50

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.

enter image description here

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

enter image description here

Subsocial answered 23/8, 2011 at 23:47 Comment(2)

That was it. thanks! (Though I don't get the point of Execute SQL at that level) – Weightless 23/8, 2011 at 23:50

The Execute SQL at the Control flow is meant to execute a stand=alone command, or to get back a recordset that you can loop through in the For-Each loop (among other things) – Subsocial 23/8, 2011 at 23:52

In SQL 2012 / VS 2010, the Execute SQL Task only appears in the Favorites bar at the top. This is confusing - why is it only a favourite?

enter image description here

You can however right-click and "move" to Common, but not "copy" to Common:

enter image description here

Silurian answered 17/9, 2013 at 2:55 Comment(1)

You have to click on "Control Flow" in the SSIS Design screen near the top, in order to see "Execute SQL Task" in the SSIS Toolbox. This also works in Visual Studio 2019 with the "SQL Server Integration Services Projects" extension added. – Garvin 27/8, 2019 at 16:31

I had this issue in VS 2010 and VS 2012. To fix it, here's what I had to do:

Exit Visual Studio
Navigate to %USERPROFILE%\AppData\Local\Microsoft\VisualStudio
Go to the folder for your version (e.g. 11.0 for VS 2012)
Rename all *.tbd files, e.g. to *.tbd.old
Open visual studio
Open toolbox by going to View > Other Windows > SSIS Toolbox

Bacteriolysis answered 17/11, 2014 at 19:56 Comment(0)

I had this in VS 2022 and the reason was, Deployment Target Server Version was set to 2017.

The minute I changed it to 2022, I got all the items in the toolbox.

Right Click SSIS Project -> Properties -> Configuration Properties -> General

Nunciature answered 4/7, 2023 at 10:28 Comment(0)

Recommended topics

Hot tags