O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Preparing and installing SQL Server Integration Services

The first release of Integration Services in SQL Server 2005 has changed the ETL functionality for SQL Server. It is a successor to SQL Server 2000 version's Data Transformation Services (DTS), and took a significant step forward by providing more intuitive designers, but also a native .NET execution environment. SQL Server 2008 R2 maintains that process with a significant scalability improvement in data pipeline and data warehouse enhancements such as persistent lookups. The SSIS enhancements from SQL Server 2008 R2 are improved scripting experience, data profiling task, an enhanced ADO.NET destination adapter, which also includes an option of Use bulk insert when available to improve the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required