This book will help you get past the initial learning curvequickly so that you can get started using SSIS to transform data,create a workflow, or maintain your SQL Server. Offering youhands-on guidance, you'll learn a new world of integrationpossibilities and be able to move away from scripting complex logicto 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 tomanage 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 toprogram custom code in all of the .NET languages. It is expectedthat you know the basics of how to query the SQL Server and havesome fundamental programming skills.
Wrox Professional guides are planned and written by workingprogrammers to meet the real-world needs of programmers,developers, and IT professionals. Focused and relevant, theyaddress the issues technology professionals face every day. Theyprovide examples, practical solutions, and expert education in newtechnologies, all designed to help programmers do a better job.
Professional SQL Server 2005 Integration Services
Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson, Kathi Kellenberger, Andy Leonard, Erik Veerman, Jason Gerard, Haidong Ji, Mike Murphy
Wiley / Wrox
| ISBN 10:
Erik Veerman is a Microsoft® MVP for SQL Server®, an award-winning BI solution developer, and a popular speaker, instructor, and author. He shares his expertise with OLAP design, ETL processing, and dimensional modeling as a mentor for Solid Quality Mentors.