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.