SQL Server 2005 Integration Services (SSIS) lets you build high-performance data integration solutions. SSIS solutions wrap sophisticated workflows around tasks that extract, transform, and load (ETL) data from and to a wide variety of data sources.
This Short Cut begins with an overview of key SSIS concepts, capabilities, standard workflow and ETL elements, the development environment, execution, deployment, and migration from Data Transformation Services (DTS).
Next, you'll see how to apply the concepts you've learned through hands-on examples of common integration scenarios.
Once you've finished this Short Cut, you'll have the background and understanding you need to start building your own SSIS integration solutions.
Bill Hamilton is the author of the highly praised Programming SQL Server 2005 and ADO.NET Cookbook. He is an enterprise architect specializing in designing, developing and implementing enterprise applications using .NET and J2EE technologies. Over the last fifteen years, Bill has provided consulting services for B2B, B2C, B2E, enterprise application integration, portal initiatives, and custom application development for financial services, retail, professional services, and manufacturing clients. Bill is also the author of O'Reilly's NUnit Pocket Reference, the co-author of ADO.NET in a Nutshell, and also writes for Microsoft Developer Network. He recently published the SQL Server 2005 Reporting Essentials shortcut.
Comments about oreilly SQL Server Integration Services:
It is all about ETL functionality and gives very well described examples. Starts with a definition and later describes various components with screenshots. It defines all the key concepts. Later focuses on migrating legacy code and has around 10 examples with different scenarios