The SSIS Execute SQL task is not part of my toolbar. How can i get it?

Question

I see some examples showing how to use the Execute SQL task. In one such example, I see this screenshot:

My task list has many tasks that I don’t have. The one I'm looking for is Run SQL.

I also note that they do not have an OLE DB command (this is what I usually used to invoke SQL).

Do I have a different version? Is the OLE DB command the successor to Run SQL? Or is there a way to get stuff that I am missing?

Answer 1

, , , ( , , ).

, , , .

, ,

Answer 2

SQL 2012/VS 2010 Execute SQL Task Favorites . - ?

"" Common, "" Common:

Answer 3

VS 2010 VS 2012. , :

• Visual Studio
• % USERPROFILE%\AppData\Local\Microsoft\VisualStudio
• Go to the folder for your version (for example, 11.0 for VS 2012).
• Rename all * .tbd files, for example. to * .tbd.old
• Open visual studio
• Open the toolbar by going to View> Other Windows> SSIS Tools

A similar problem is here: http://geekswithblogs.net/AskPaula/archive/2013/07/11/153385.aspx