Professional SQL Server 2005 Integration Services and over 360,000 other books are available for Amazon Kindle – Amazon’s new wireless reading device. Learn more

 

or
Sign in to turn on 1-Click ordering.
 
 
Express Checkout with PayPhrase
What's this? | Create PayPhrase
Sorry!
X
More Buying Choices
68 used & new from $17.33
Have one to sell? Sell yours here
 
   
Professional SQL Server 2005 Integration Services (Programmer to Programmer)
 
 
Share your own customer images
Search inside this book
Start reading Professional SQL Server 2005 Integration Services on your Kindle in under a minute.

Don’t have a Kindle? Get your Kindle here.
 
  

Professional SQL Server 2005 Integration Services (Programmer to Programmer) (Paperback)

~ (Author), Allan Mitchell (Author), Darren Green (Author), Douglas Hinson (Author), Kathi Kellenberger (Author), Andy Leonard (Author), Erik Veerman (Author), Jason Gerard (Author), Haidong Ji (Author), Mike Murphy (Author) "SQL Server Integration Services (SSIS) is one of the most powerful features in SQL Server 2005..." (more)
Key Phrases: data flow tab, data flow task, available input columns, Cancel Help Figure, Integration Services, Cancel Figure (more...)
3.7 out of 5 stars  See all reviews (33 customer reviews)
List Price: $49.99
Price: $31.49 & this item ships for FREE with Super Saver Shipping. Details
You Save: $18.50 (37%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Want it delivered Tuesday, November 10? Choose One-Day Shipping at checkout. Details
44 new from $22.43 24 used from $17.33

Formats

Amazon Price New from Used from
  Kindle Edition, January 31, 2006 $25.19 -- --
  Paperback, January 30, 2006 $31.49 $22.43 $17.33

Frequently Bought Together

Professional SQL Server 2005 Integration Services (Programmer to Programmer) + Expert SQL Server 2005 Integration Services (Programmer to Programmer) + The Rational Guide to Extending SSIS 2005 with Script (Rational Guides)
Price For All Three: $79.47

Show availability and shipping details

  • This item: Professional SQL Server 2005 Integration Services (Programmer to Programmer) by Brian Knight

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Expert SQL Server 2005 Integration Services (Programmer to Programmer) by Brian Knight

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • The Rational Guide to Extending SSIS 2005 with Script (Rational Guides) by Donald Farmer

    In Stock.
    Ships from and sold by Amazon.com.
    Eligible for FREE Super Saver Shipping on orders over $25. Details

Customers Who Bought This Item Also Bought

Professional SQL Server 2005 Reporting Services

Professional SQL Server 2005 Reporting Services

by Paul Turley
3.2 out of 5 stars (17)  $26.39
The Rational Guide to Extending SSIS 2005 with Script (Rational Guides)

The Rational Guide to Extending SSIS 2005 with Script (Rational Guides)

by Donald Farmer
4.6 out of 5 stars (5)  $16.49
Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer)

Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer)

by Sivakumar Harinath
3.4 out of 5 stars (9)  $31.49
Microsoft SQL Server 2005 Reporting Services

Microsoft SQL Server 2005 Reporting Services

by Brian Larson
4.2 out of 5 stars (50)  $31.49
Microsoft SQL Server 2005 Unleashed

Microsoft SQL Server 2005 Unleashed

by Ray Rankins
4.4 out of 5 stars (20)  $40.94
› Explore similar items

Editorial Reviews

Product Description

This book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server. Offering you hands-on guidance, you'll learn a new world of integration possibilities and be able to move away from scripting complex logic to 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 to manage 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 to program custom code in all of the .NET languages. It is expected that you know the basics of how to query the SQL Server and have some fundamental programming skills.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.



From the Back Cover

This book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server. Offering you hands-on guidance, you'll learn a new world of integration possibilities and be able to move away from scripting complex logic to 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 to manage 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 to program custom code in all of the .NET languages. It is expected that you know the basics of how to query the SQL Server and have some fundamental programming skills.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

See all Editorial Reviews

Product Details

  • Paperback: 720 pages
  • Publisher: Wrox; illustrated edition edition (January 31, 2006)
  • Language: English
  • ISBN-10: 0764584359
  • ISBN-13: 978-0764584350
  • Product Dimensions: 9 x 7.3 x 1.6 inches
  • Shipping Weight: 1.3 pounds (View shipping rates and policies)
  • Average Customer Review: 3.7 out of 5 stars  See all reviews (33 customer reviews)
  • Amazon.com Sales Rank: #210,425 in Books (See Bestsellers in Books)

    •  Would you like to update product info or give feedback on images?

More About the Author

Brian Knight
Discover books, learn about writers, read author blogs, and more.

› Visit Amazon's Brian Knight Page
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
Search Inside This Book:
Inside This Book (learn more)
First Sentence:
SQL Server Integration Services (SSIS) is one of the most powerful features in SQL Server 2005. Read the first page
Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
data flow tab, data flow task, available input columns, data from the data flow, data access mode, dtsx file, flat file source, raw file destination, raw file source, lockbox file, fuzzy lookup, team foundation server, conditional split transform, lookup transformation, constraints interoperate, command access mode, incoming data source, new connection manager, error folder, rerun the package, script task, log provider, loop container, source adapter, data flow components
Key Phrases - Capitalized Phrases (CAPs): (learn more)
Cancel Help Figure, Integration Services, Cancel Figure, Analysis Services, Union All, Data Reader, Import Column, Team System, Check Inventory Level, Server Management Studio, Solution Explorer, Package Explorer, Reporting Services, Event Watcher, Export Column, Program Files, Design Script, Adventure Works, Ray Leonard, Term Lookup, Character Map, Output Work List, Parameter Mapping, Add Column, Books Online
New!
Books on Related Topics | Concordance | Text Stats
Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
Search Inside This Book:
Citations (learn more)
This book cites 3 books:

Books on Related Topics (learn more)
 
 

What Do Customers Ultimately Buy After Viewing This Item?

Professional SQL Server 2005 Integration Services (Programmer to Programmer)
64% buy the item featured on this page:
Professional SQL Server 2005 Integration Services (Programmer to Programmer) 3.7 out of 5 stars (33)
$31.49
Expert SQL Server 2005 Integration Services (Programmer to Programmer)
14% buy
Expert SQL Server 2005 Integration Services (Programmer to Programmer) 4.3 out of 5 stars (14)
$31.49
Hands-On Microsoft SQL Server 2005 Integration Services
10% buy
Hands-On Microsoft SQL Server 2005 Integration Services 4.0 out of 5 stars (10)
$32.99
The Rational Guide to Extending SSIS 2005 with Script (Rational Guides)
6% buy
The Rational Guide to Extending SSIS 2005 with Script (Rational Guides) 4.6 out of 5 stars (5)
$16.49
Explore similar items

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(11)
(9)
(7)
(4)
(2)
(1)
(1)
(1)
(1)
See all 10 tags...

Your tags: Add your first tag
 
See most popular tags
 

Customer Reviews

33 Reviews
5 star:
 (14)
4 star:
 (6)
3 star:
 (5)
2 star:
 (6)
1 star:
 (2)
 
 
 
 
 
Average Customer Review
3.7 out of 5 stars (33 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
100 of 102 people found the following review helpful:
3.0 out of 5 stars Hang on a sec.... have any of the reviewers ACTUALLY READ this book??, March 11, 2006
While I share the enthusiasm of the other reviewers, I'm not entirely convinced that any of them have read far enough to give the book 5 stars. I have nearly 10 years under my belt in BI, worked with SQL Server extensively, and not too shabby in the .NET department either; to be certain, SSIS 2005 is truly groundbreaking. However, the watchful readers will find a hurried book in their hands, one numerous typos and misleading information. For example, while I was able to figure out the nature of the strongly-typed properties of the incoming Row object for the Script Component example (Chapter 7) (you need to define the "Cleaned" ones yourself in the Script Transformation Editor to support the code for your Script Component), the book isn't completely clear and such information may not be so apparent to those new to the SSIS (or ETL) experience. Donald Farmer's book covering SSIS 2005 Scripting (the beta version) covers the Script Task and Script Component Transform Task better than Professional SQL Server 2005 Integration Services. Whilst I have focused on Chapter 7, I have found this pattern throughout the book. To be clear, I'm not terribly displeased with this book... it provides just enough coverage of the new product to get you going (with a welcome "under the hood" look at the SSIS engine) it's just that a 2nd Edition is required from WROX/WILEY to clean up its somewhat misleading content.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
35 of 37 people found the following review helpful:
1.0 out of 5 stars Pick another book!, June 24, 2007
By Pen Name (Phoenix, AZ) - See all my reviews
***NOTE TO WROX*** Before you release a tutorial, have someone other than the authors (or their friends) try each and every lesson!

This has to be one of the WORST tutorial/step-by-step books ever written.

I'm a seasoned DBA that has worked on every version of MS-SQL ever released. Starting with 4.9.2. I've also worked on Sybase, Oracle, Postgress and MySQL. Add to this several years of VB/C experience and time spent as a corporate trainer, and you can guess my technical aptitude. My experience with DTS/ETL includes hundreds (if not thousands) of packages on 7.0 & 2000. This book was purchased as a means of ramping up for a new consulting gig on SSIS. It was a complete waste of money.

The "tutorials" are disorganized, confusing, and the instructions don't match the examples. Even more annoying are the sections that appear to be lessons that aren't. You won't realize this until you start inputting the example and then get to a new paragraph that tells you this subject will be covered in another chapter. Even worse are the real examples whose instructions refer you back to a step that was left out or edited out of the book. This begins in chapter two when you are told to create a new "project" and then later told to add another project to the "solution", but, there was never any mention on how to start a "solution". This sets the tone for the rest of the book. You'll learn early on to read the entire chapter, then go back to the beginning and "try" the examples. Don't even get me started on the explanations being on one page, while the diagrams for the explanation are on the back of that page. Read a few sentences; turn the page to see the diagram; turn back to read some more; turn back to see the diagram (lather, rinse, repeat...)

It normally takes me only a few hours to breeze through five or six chapters of a technical tutorial. After TWO DAYS (a full Saturday and Sunday) of frustration that got me as far as half way through the fourth chapter, I discarded the book, drove to a local bookstore and bought something else off the self.

Rule #1 for tutorial books: The instructions must be COMPLETE.
Rule #2: The instructions must be in the order necessary to complete the lesson, (ie. 1-2-3-4, not, 1-4-3-5, oops...did we forget or edit out a step?)
Comment Comments (4) | Permalink | Was this review helpful to you? Yes No (Report this)



 
29 of 30 people found the following review helpful:
2.0 out of 5 stars Okay, but a little bit disappointing too, July 24, 2006
I bought this book and had a lot of expectations. 10 Writers were involved to write this book which covers a complete new software tool from Microsoft, introduced with the newly released SQL Server 2005 replacing the DTS Service of SQL Server 2000 and earlier Versions plus adding tons of new features to the enterprise Database Solution which were previously unavailable.

The fact that 10 people contributed to it can be felt throughout the book, because no or little efforts were made to keep the writing style consistent. That can be a bit confusing at times.

Also when it comes to the content, are a lot of things not covert at all or not very well. When I did seek the help from the book for the first time for a very specific problem I tried to solve with SSIS, did the book fail to provide the answers to me. It addressed the problem, but it only addressed the stuff I already figured out myself. To the item I had my problem with did only exist a side note which did not help me at all. That was already a bad start.

I am looking for better alternatives which I have not found yet. It is probably good for somebody who wants to get an overview or general idea of the new Service, but might be the wrong choice for somebody who has specific applications in mind and tries to find answers to problems in this book.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews

4.0 out of 5 stars Worthy introduction to SSIS
I read the book, followed the examples. This was a worthy introduction to SSIS and gave me a good start on my new job writing ETLs. Read more
Published 8 months ago by Dale Withroder

2.0 out of 5 stars Half baked product
Yes, authors are very knowledgeable, but the book is very difficult to read and to learn SSIS.
I am DBA/ Data Warehousing / ETL developer with over 10 years in the field and... Read more
Published 10 months ago by DBguru

5.0 out of 5 stars Very informative!
So far this book is great for basics. It gives a great overview of all the options you have to create a SSIS package. Read more
Published 17 months ago by Phil P

3.0 out of 5 stars Too many authors; too little coherence
I originally intended to give this book two (2) stars, just because I was hacked off at the terrible index, but the content is worth at least three stars. Read more
Published 17 months ago by Clyde LeBonz

4.0 out of 5 stars Lots of breadth, good place to start
If you're needing an SSIS primer, this is a great place to start. There are definitely holes the "how to" part of some sections. Read more
Published 19 months ago by James A. Russell

5.0 out of 5 stars Everything is good
The book was in perfect condition and delivered promptly. The information contained in the book was very informative and helpful. The writers explained the concepts clearly.
Published 20 months ago by Jose Tigeleiro

3.0 out of 5 stars Good, but where's the VB sample code?
SSIS only supports scripting in VB. But whenever there's a custom component or any code outside the mandatory VB realm, the book only presents a C# example. Read more
Published 20 months ago by Ernest A. Ostrander

2.0 out of 5 stars Conceptual Integration Lacking
While this text does contain quite a bit of information about SSIS and its functionality, it does not do a good job of relating or building an overarching conceptual framework for... Read more
Published 23 months ago by John M. Cunha

4.0 out of 5 stars Great Book
This is a good book on some very practical examples for all types of transformations within SSIS. Definitely recommend this book if you are having diffciulty in piecing together... Read more
Published on October 21, 2007 by Mr. Steve Kossaris

4.0 out of 5 stars Not too bad for a technical book.
I am about 1/3 through the Professional SQL Server 2005 Integration Services book. It was worth buying. I don't view this as a Step-By-Step type book. Read more
Published on August 22, 2007 by N. W. Dismukes

Only search this product's reviews


Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   

So You'd Like to...


Create a guide

Product Information from the Amapedia Community

Beta (What's this?)

Look for Similar Items by Category

Look for Similar Items by Subject

Search Books by subject:














i.e., each book must be in subject 1 AND subject 2 AND ...
 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.


Your Recent History

 (What's this?)

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.