If I understood you correctly, the easiest way to get there is to use "SQL Command".

Use a Data Flow Task and then choose a source you want (probably OLE DB...