Ebooks Link Collection and Review

Author: Jayaram Krishnaswamy
Publisher: Packt Publishing
First published: December 2007

Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 provides you with the basic knowledge that you should have before you move onto more advanced ETL (Extraction, Transformation, and Loading). This step-by-step, hands-on guide will take you right into the Visual Studio 2005 Integrated Development Interface, making you appreciate and understand how Business Intelligence Projects and Packages are created using the Visual Studio designer. The book will also provide you with a comprehensive description of the many designer windows that you may encounter while working with the designer. This guide provides the building blocks, describing each block by way of an example, as well as describing the nuts and bolts that bind the blocks. You start building packages right from Chapter 2 and continue onto Chapter 20, gathering and building upon your knowledge in each step.

This book is written for beginners in the developer track who are looking to get an exposure to SQL Server Integration Services; DBA's who are testing water with the Visual Studio IDE but without a wide programming experience; SQL 2000 Data Transformation Services users who are trying to move into SQL Server 2005 Integration Services; Microsoft programming professionals in Small Businesses who wear multiple hats (jack of all trades)—developer, programmer, and DBA with a little bit of experience in each of these.

It is expected that you know how to manipulate window objects, like clicking; dragging and dropping; using contextual help; tabbing, etc. It is also expected that you are exposed to SQL Server database basics and that you understand connecting to a database server; querying the database; reviewing objects; displaying and reviewing properties of objects, etc. Very little coding skill is assumed except that you can logically follow a fully commented code.

Download: