Integration Services (SSIS)

Technical Article

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

  • Article

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.

2009-06-01

7,208 reads

Blogs

Microsoft Ignite Announcements Nov 2024

By

Announced at Microsoft Ignite last week were some new product features related to the...

SQL Training: Black Friday Deals Up to 75% Off

By

This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...

When is the perfect moment to build a data strategy in a company?

By

The post When is the perfect moment to build a data strategy in a...

Read the latest Blogs

Forums

% processor Time in Activity monitor is greyed out

By IT researcher

When I connect to my SQL Server using SQL Server Management Studio (SSMS) from...

Tools for MySQL memory estimations and optimization?

By EdZzy

Hi all! I’ve been using MySQLCalculator.com for memory calculations, but I’m looking for alternatives...

DELETE

By 0xERROR

DELETE  

Visit the forum

Question of the Day

The Hash Join II

Which of these inputs is the smaller input to a hash join?

See possible answers