SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags SQL Server 2008, Extract, Transform, Load (ETL), Integration Services (SSIS) Rss

   Items 1 to 3 of 3   

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

In February 2008, Microsoft announced a record-breaking data load using Microsoft® SQL Server® Integration Services (SSIS): 1 TB of data in less than 30 minutes. That data load, using SQL Server Integration Services, was 30% faster than the previous best time using a commercial ETL tool. This paper outlines what it took: the software, hardware, and configuration used. We will describe what we did to achieve that result, and offer suggestions for how to relate these techniques to typical scenarios.  Read more...
Rating:  Rate this |   Briefcase | 7,050 reads

The Data Loading Performance Guide

This document described techniques for bulk loading large data sets into SQL Server. It covers both the available techniques as well as methodologies to performance tune and optimize the bulk loading process.  Read more...
By Additional Articles 2009/02/24 | Source: MSDN Communities | Category: sql server 2008
Rating:  Rate this |   Briefcase | 3,778 reads

Build a Metadata-Driven ETL Platform by Extending Microsoft SQL Server Integration Services

SQL Server 2008 Integration Services (SSIS) provides a flexible and scalable architecture that enables high-performance data extract, transform, and load (ETL). The Microsoft Business Intelligence Center of Excellence has extended SSIS to a metadata-driven platform to more effectively build, deploy, and manage ETL processes in large data warehousing environments.  Read more...
Rating:  Rate this |   Briefcase | 3,681 reads
   Items 1 to 3 of 3   
bulk import (1)