Professional SQL Server 2005 Integration Services (Programmer to Programmer)

This book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server. Offering you hands-on guidance, you'll learn a new world of integration possibilities and be able to move away from scripting complex logic to programming tasks using a full-featured language. What you will learn from this book Ways to quickly move and transform data How to configure every aspect of SSIS How to interface SSIS with web services and XML Techniques to scale the SSIS and make it more reliable How to migrate DTS packages to SSIS How to create your own custom tasks and user interfaces How to create an application that interfaces with SSIS to manage the environment A detailed usable case study for a complete ETL solution Who this book is for This book is for developers, DBAs, and users who are looking to program custom code in all of the .NET languages. It is expected that you know the basics of how to query the SQL Server and have some fundamental programming skills. Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job. "With the 2005 release of SQL Server Integration Services, developers will need to throw existing knowledge out the window and be prepared to start anew. This book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server. Offering you hands-on guidance, you'll learn a new world of work integration possibilities and be able to move away from scripting complex logic to programming tasks using a full-featured language." "This book is for developers, DBAs, and users who are looking to program custom code in all of the .NET languages. It is expected that you know the basics of how to query the SQL Server and have some fundamental programming skills."--Jacket Provides information on design, development, and connectivity to other systems using integration services of SQL Server 2005. SQL Server Integration Services (SSIS) is one of the most powerful features in SQL Server 2005.