O'Reilly logo
  • Marshall Pettit thinks this is interesting:

For your larger tables, you may instead want to consider Integration Services. Integration Services offers greater functionality and arguably more end-to-end convenience. This is because Integration Services is able to connect directly to the data source and load the data into the PDW appliance without having to stop at a file share. Another important distinction is that Integration Services can also perform transformations in flight, which DWLoader does not support.


Cover of SQL Server Integration Services Design Patterns, Second Edition


Best approach utilizes both DWLoader and Integration Services