Pro SQL Server 2008 Integration Services is the complete reference on Microsoft SQL Server 2008's built-in tool set for extraction, transformation, and load (ETL) projects. Completely updated to cover the very latest features, this book shows how to develop and deploy Integration Services solutions that will scale to load anything from a dozen rows to a billion, or many billions!
- Completely revised and updated for SQL Server 2008
- Soup-to-nuts–covers everything you need to be productive with Integration Services
- Illustrates best–practice methods yielding solid results for even the most demanding of users
Integration Services is the right tool to use for moving data between operational and reporting database environments. Integration Services also lets you move data from nonrelational systems into SQL Server, and vice versa. Integration Services is reliable, it is automated, it will save you time. Pro SQL Server 2008 Integration Services by Dandy Weyn is your guide to making the most of one of Microsoft's most versatile tools.
What you'll learn
- Design and automate data flows to and from databases and data warehouses
- Implement data transformations in SSIS without writing custom code
- Take full advantage of the latest enhancements in SSIS 2008
- Create custom components to support your most complex ETL needs
- Optimize your ETL flows and solve SSIS performance problems
- Write .NET code that runs inside SQL Server 2008
- Integrate SQL Developer into your general development tool set
Who is this book for?
Pro SQL Server 2008 Integration Services is written for developers and database administrators involved in data extraction, transformation, and loading (ETL) projects. The book helps readers take full advantage of Integration Services to automate the movement and manipulation of data between different databases and nondatabase sources.
About the Apress Pro Series
The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder.
You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard–won solutions to problems you will face in your professional programming career.
