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

CREATE DATABASE PDW_Destination_Example
WITH
(

REPLICATED_SIZE = 1 GB

, DISTRIBUTED_SIZE = 5 GB

, LOG_SIZE = 1 GB

);

CREATE TABLE PDW_Destination_Example.dbo.FactSales
(

orderID INT

, orderDate DATETIME

, customerID INT

, webID CHAR(38)

)
WITH
(

DISTRIBUTION = HASH (orderID)
, CLUSTERED COLUMNSTORE INDEX

);

Now that the destination objects are created, we can return to the Integration Ser-
vices package. Drag the SQL Server PDW Destination from the Toolbox to the Data
Flow pane. Double-click on the SQL Server PDW Destination, illustrated in Figure
8-6 , to edit its configuration.

Figure 8-6 . The SQL Server PDW Destination

Next, click on the down arrow next to Connection Manager and select <Create
New Connection. . .>, as shown in Figure 8-7 .