How do I get the SSIS "SQL Command" into my tool box?

O.K. - I admit I'm an SSIS rookie.  This is my forst SSIS project.

When I open Visual Studio, and say I want to start a new "Integration Services" project, I get a work bench and tool box as I expect.  In the tool box, I see transfermations like Pointer, Aggrigate, OLE DB Command. Pivot, Script and Sort - but I don't see a "SQL Command".  If I go to Management Studio and perform the export data scenario I want to do, save the SSIS .dtsx file, and then move that file to my SSIS project and open it, I see something with a Property Type of "Data Flow Component" and an Access Mode of "SQL Command".  How do I get this "SQL Command" object into my tool box?  Am I missing a DLL I need to assign or the like?

Thanks in advance.
jflannerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

chapmandewCommented:
It is under the Control Flow Items toolbar and is named "Execute SQL Task"
0
brejkCommented:
In Control Flow there is Execute SQL Task available in the Toolbox. However, if you are going to transfer data between two data sources then you have to create Data Flow Task and put the data sources in it (SQL Command is then just one of the properties of data source).
0
jflannerAuthor Commented:
brejk:

You are very close.  I have a dataflow task called "Copy Data".  It is the only thing in my Control Flow now.  And you guys are both correct, when in Control Flow I see the SQL Command in my tool box.  But when I go to my Data Flow task - where I want to use it - it is not there.  If I go to Control Flow - pick it out of the tool box and attempt to drop it on the Data Flow task, that does not work.  It simply drops it on top of the Data Flow - not in it.

I appreciate very much the help.  Please help me get these last 10 yards.
0
chapmandewCommented:
You can't use execute sql from the data from tab.  

If you could use it....what would you be trying to accomplish with it?  I've ran into a few situations like this, but I have ended up solving it by using another means in the data flow.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
brejkCommented:
@jflanner:

Go to Dat Flow. From Toolbox drag some data source and data destination. Connect source and destination. Configure connections for both of them. Choose SQL Command in data source (instead of single table or view). Then configure column mappings between source and destination.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.