Loading Data with Dwloader & SSIS for MS PDW

In this video post I will show you how fast you can load data into your PDW with Dwloader & SSIS. This is a demo about my previous posts on DWloader, but also contains the demo for SSIS.

Advertisements
Tagged , , , ,

2 thoughts on “Loading Data with Dwloader & SSIS for MS PDW

  1. Suman says:

    This is excellent demo for loading data as Full Load. How can I load an incremental data _ Currently I am using Hashbytes to find the delta of data in SMP process , which is not supported in PDW.
    In my current system Checksum or Datekey not worked properly.
    What is the replacement of Hashbytes here ?

  2. swyskoh says:

    Hi Suman,

    The way we do it is by using partitioned tables and do this with partition switching.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: