You can have multiple OLE DB sources in your dataflow. Each of them executes one SQL query. You can append to resultsets to each other using the UNION ALL component if each resultset has the same layout. If they have different layouts you'd need different dataflows for each SQL query.