Item description for The Rational Guide to Extending SSIS 2005 with Script (Rational Guides) (Rational Guides) by Donald Farmer...
The Integration Services feature of Microsoft SQL Server 2005 brings together data from diverse sources in a high-performance data integration platform, to enable users to work across multiple applications that may not have been designed to cooperate. In this book, Donald Farmer, Microsoft's Group Program Manager for SQL Server Integration Services, clearly explains how to build practical and useful scripts for this exciting new SQL Server 2005 feature. His systematic approach, friendly tutorials, and numerous examples are suitable for both developers and IT professionals alike. You'll learn how scripting in SQL Server Integration Services can enable you to easily add new, fully-integrated functionality to achieve your enterprise data integration needs.
This book takes a rational, no-nonsense approach in a compact guide - only 224 pages. The book is written to give you the basics...fast!
Technical Accuracy is assured by Ashvini Sharma, Development Lead, SQL Server Integration Services, Microsoft Corporation.
* Bonus Chapter: "Monitoring SSIS Performance with Scripts" * Bonus Chapter: "Accessing Web Services with SSIS Scripts" * Bonus Chapter: "Using SSIS as a Data Service" * Sample code for the examples in the book
Promise Angels is dedicated to bringing you great books at great prices. Whether you read for entertainment, to learn, or for literacy - you will find what you want at promiseangels.com!
Est. Packaging Dimensions: Length: 0.5" Width: 6.25" Height: 9" Weight: 0.7 lbs.
Release Date Mar 1, 2007
Publisher Rational Press
ISBN 1932577254 ISBN13 9781932577259 UPC 827188021135
Availability 0 units.
More About Donald Farmer
Donald Farmer has worked in the Microsoft Business Intelligence team for 7 years. He has worked on both the Analysis Services and Integration Services product teams. Donald is now a Principal Program Manager for SQL Server Analysis Services, working to build the new generation of analytic technology, including predictive analysis, within the Microsoft business intelligence offering. Donald is a popular speaker at international events for both business and technical audiences, with a wide range of interests including data integration, information quality, meta data intelligence, master data management and predictive analytics. He is the author of a number of books and articles. Prior to joining Microsoft, Donald worked not only in business intelligence but in fields as varied as medieval archaeology and fish-farming.
Reviews - What do customers think about The Rational Guide to Extending SSIS 2005 with Script (Rational Guides) (Rational Guides)?
immensely useful, a gem Apr 6, 2008
Microsoft SQL Server Developer Edition 2005 CD/DVD Microsoft SQL Server 2005 Integration Services (SSIS) is a tool for developing and running data integration tasks, such as reading from files, transforming data, and loading data into databases, including, but not limited to, Microsoft SQL Server. It is an "ETL" (extract, transform, load) product, very powerful but easy to get lost in the product's documentation and whitepapers trying to figure out how to accomplish a given real-world task. Farmer's little book is a gem because it is short and it makes an effort to help a developer with real-world data integration tasks. This book's main theme is using the scripting facilities, but it does a good job giving a perspective. Donald Farmer is the SSIS program manager at Microsoft, and besides technical knowledge, he has the skills to educate. I have always felt that there are lots of great software products available, but that developers trying to solve problems have a hard time getting past the product demos and slides. This book, in the tradition of K&R's "The C Programming Language" helps developers take that step. In contrast, books that describe step-by-step procedures that are already described in the product documentation are not nearly as useful. While SSIS has lots of toolboxes to do standard ETL tasks, scripting tasks are meant to add facilities that are awkward or impossible to do with standard designs. Scripting has access to the NET Framework and user-developed NET assemblies. Farmer's examples are helpful and inspiring. I hope he will write more books like this, but at the same time I like to see him, as product manager, take some annoyances and weaknesses out of the otherwise great SSIS product. Those who like to watch instructional videos will enjoy his presentations on MSDN TV.
very helpful book in getting more out of SSIS 2005 Apr 5, 2008
If you need to get moe out of SSIS 2005 and don't want to waste time re-inventing the wheel; this book is a great help. Examples were very helpful to push the SSIS a bit further.
Powerful and concise Jun 29, 2007
This is an excellent book. It shows how to unleash the power of SSIS. Script (writing code) is the way to go when you need go beyond the tasks and transformations that are built into SSIS. This book shows how to customize, control, extend and monitor SSIS through code.
One of the best things about the book is that it is only around 200 pages. This book won't put you to sleep with the history of relational databases and ETL or trying to teach you Visual Basic.net. You will appreciate that if you are an experienced database and .net developer. [...] The author helped to develop the product and is thoroughly knowledgeable about the subject. He is active in the Integration Services support forums.
There are some typos but they are easy to spot and do not cloud the information. I highly recommend this book.