SSIS

TwitterFacebook
Get flash to fully experience Pearltrees

Implementing Lookup Logic in SQL Server Integration Services

With SSIS, you can perform a lookup on data in the course of a task, using referenced data from any OLE DB source. It is a useful feature that enables you to check on the validity of data, or interpret it before proceeding. Robert Sheldon explains. https://www.simple-talk.com/sql/ssis/implementing-lookup-logic-in-sql-server-integration-services/
SQL Server Technical Article Writers: Len Wyatt, Tim Shea, David Powell Published: March 2009

We Loaded 1TB in 30 Minutes with SSIS, and So Can You

http://msdn.microsoft.com/en-us/library/dd537533(v=sql.100).aspx
http://microsoft-ssis.blogspot.com/2011/07/balanced-data-distributor.html

Balanced Data Distributor

A few weeks ago Microsoft quietly released a new Data Flow transformation for SSIS 2008 and 2008 R2: Balanced Data Distributor. This transform takes a single input and distributes the incoming rows to one or more outputs uniformly via multi-threading. UPDATE: 2012 version has been released How does it work?
The most flexible way to bulk-load data into SQL Server is to use SSIS. It can also be the fastest, and scaleable way of doing so. There are three different components that can be used to do this, using SSIS, so which do you choose? https://www.simple-talk.com/sql/reporting-services/using-sql-server-integration-services-to-bulk-load-data/

Using SQL Server Integration Services to Bulk Load Data

SSIS Balanced Data Distributor - Microsoft Download Center - Download Details

http://www.microsoft.com/en-us/download/details.aspx?id=4123 Overview Microsoft® SSIS Balanced Data Distributor (BDD) is a new SSIS transform. This transform takes a single input and distributes the incoming rows to one or more outputs uniformly via multithreading.