- Paperback: 197 pages
- Publisher: RATIONAL PRESS; illustrated edition edition (3 Jan 2007)
- Language English
- ISBN-10: 1932577254
- ISBN-13: 978-1932577259
- Product Dimensions: 22.4 x 15.2 x 1.5 cm
- Average Customer Review: 5.0 out of 5 stars See all reviews (1 customer review)
- Amazon Bestsellers Rank: 612,004 in Books (See Top 100 in Books)
- See Complete Table of Contents
 Trade In this Item for up to £9.00
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in The Rational Guide to Extending SSIS 2005 with Script (Rational Guides) for an Amazon.co.uk gift card of up to £9.00, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Product details |
More About the Author
Inside This Book
(Learn More)
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
1 of 1 people found the following review helpful
Format:Paperback
The book covers several examples of how to use the script component within the SSIS toolset. The examples have been selected to cover a multitude of possible real life applications, from a simple date decision task to a task connecting to a web service from inside the SSIS toolset. It assumes limited knowledge of VB .Net development and a reasonable level of understanding of SSIS.
The book is very well written and contains detailed instructions of how to create the examples it uses to demonstrate the flexibility of the script task.
The book is very well written and contains detailed instructions of how to create the examples it uses to demonstrate the flexibility of the script task.
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
7 reviews
11 of 11 people found the following review helpful
Powerful and concise
29 Jun 2007
Format:Paperback|Amazon Verified Purchase
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.
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.
6 of 6 people found the following review helpful
immensely useful, a gem
6 April 2008
Format:Paperback|Amazon Verified Purchase
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.
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.
5 of 7 people found the following review helpful
For basic referece
27 Oct 2008
Format:Paperback|Amazon Verified Purchase
If you are expecting some more practical world work example then you get surprised with the book material.
The better book i found is expert SSIS by wrox production..This is not worth to pay $16.If you are getting in cheap price then plan to buy it.
I Personally do not like this book.
The better book i found is expert SSIS by wrox production..This is not worth to pay $16.If you are getting in cheap price then plan to buy it.
I Personally do not like this book.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
