Loading a PDW Region in APS - SQL Server Integration Services Design Patterns - page 244

Add a Data Flow task to the control flow designer surface. Name it PDW Import .
Add an OLE DB Source to the designer surface from the SSIS Toolbox. Edit the
properties of the OLE DB Source by double-clicking on the icon. You should see the
source editor shown in Figure 8-2 .
Figure 8-2 . The OLE DB Source Editor
You will need to create an OLE DB Connection Manager that points to the
PDW_Example database. Once this is done, change the data access mode to SQL
Command ; then enter the code in Listing 8-4 .
Listing 8-4 . Example SQL Command
/* Retrieve sales for 2013 */
SELECT