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

SQL Server PDW
Data Type

Integration Services Data Type(s) That Map to the SQL Server
PDW Data Type

TINYINT DT_I1

VARBINARY DT_BYTES

VARCHAR DT_STR

Also, it is worth noting that PDW does not currently support the following data
types at the time of this writing:

• DT_DBTIMESTAMPOFFSET

• DT_DBTIME2
• DT_GUID
• DT_IMAGE

• DT_NTEXT
• DT_TEXT

Any of these unsupported data types will need to be converted to a compatible data
type using the Data Conversion transformation. We will walk through how to perform
such a transformation in just a moment.

Data Import Pattern for PDW

Now that you have a basic understanding of the architecture and loading concepts of an
APS appliance, we're ready to get started with the pattern for importing data into PDW.

Prerequisites

All Integration Services packages will be executed from a loading server. A loading
server is a non-appliance server that resides on your network and runs Windows Server
2008 R2 or newer. The loading server is connected to the APS appliance via Ethernet
or InfiniBand, the latter of which is recommended for better performance. Additionally,
the loading server will require permissions to access the Control node and must have
Integration Services and the PDW destination adapter installed.