CODEWITHSUNDEEP
ssis
Vaccano
Vaccano

Reputation: 82437

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

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?

Upvotes: 8

Views: 22824

Answers (4)

Michael
Michael

Reputation: 1

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

Upvotes: 0

FistOfFury
FistOfFury

Reputation: 7155

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

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

Similar problem here: http://geekswithblogs.net/AskPaula/archive/2013/07/11/153385.aspx

Upvotes: 0

PeterX
PeterX

Reputation: 2901

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

Upvotes: 6

Raj More
Raj More

Reputation: 48024

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

Upvotes: 8

Related Questions