SQL Server 2005 Integration Services Advanced Programming

Author: (USA) Night
Publisher:
Publish Date: 2007-01-01
Features: With the release of SQL Server Integration Services (SSIS) 2005, developers will need to discard their previous knowledge of DTS and be prepared to start learning from scratch. This is because the SSIS environment has evolved from an inconspicuous feature of SQL Server into a completely new, enterprise-level Extract, Transform, Load (ETL) tool. This book will help you smoothly navigate the initial learning curve, enabling you to quickly master using SSIS to transform data, create workflows, or maintain SQL Server. Through the practical guidance provided in this book, you will explore the integrated capabilities of this new field and be able to move away from complex logic script programming, instead using a fully functional language to program tasks. What You Will Learn from This Book · Methods for quickly transferring and transforming data · How to configure various aspects of SSIS · How to interact with Web services and XML using SSIS · Techniques to make SSIS more scalable and reliable · How to migrate DTS packages to SSIS · How to create your own tasks and user interfaces · How to create applications that interact with SSIS to manage the environment · A comprehensive case study of a complete ETL solution Target Audience This book is intended for developers, DBAs (Database Administrators), and users who want to write custom code in all .NET languages. It is assumed that readers have a basic understanding of querying SQL Server and possess preliminary programming skills.