Connections > Excel
  
Excel
Note: For more information on how to use SSIS loading in Data Warehouse Designer , see How to use SSIS loading (see "How to use SSIS loading in Data Warehouse Designer" on page 247)
 
Windows
This connection is back to the PC that you are working on, or to a host Windows PC. From Windows you can only do flat file loads.
Sample SQL Server Windows connection screen: