Microsoft SQL Server 2008 Integration Services Problem-Design-Solution
Written by a team of Microsoft MVPs for SQL Server, this book presents you with an array of common problems that SSIS administrators and developers face on a daily basis, and walks you through the steps necessary to solve these challenges.
We bring you the introductory chapter of this book, looking at how you should begin to set up your solution.
Get a feel for this book from
2010-02-09
2,101 reads
The provided SSIS package contains a single script task that will script all SQL Server 2000/2005/2008 Agent Jobs into individual files.
2010-07-06
12,610 reads
Caught in between upgrades, new author Mohan Jumar has an interesting article. Using Visual Studio 2005 to save packages in an SSIS 2008 package store.
2009-08-13
4,993 reads
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
See how the data preparation tasks within SSIS can be used to retrieve data or to validate the quality of data.
2009-05-28
2,252 reads
