Professional SQL Server 2005 Integration Services

( 2 )


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 ...

See more details below
$32.24 price
(Save 35%)$49.99 List Price
Other sellers (Paperback)
  • All (33) from $1.99   
  • New (7) from $5.99   
  • Used (26) from $1.99   
Sending request ...


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.

Read More Show Less

Product Details

  • ISBN-13: 9780764584350
  • Publisher: Wiley
  • Publication date: 1/31/2006
  • Series: Programmer to Programmer Series
  • Edition number: 1
  • Pages: 720
  • Product dimensions: 9.08 (w) x 11.00 (h) x 1.48 (d)

Meet the Author

Brian Knight, SQL Server MVP, MCSE, MCDBA, is the cofounderof and was recently on the Board of Directorsfor the Professional Association for SQL Server (PASS). He runs thelocal SQL Server users group in Jacksonville, Florida (JSSUG).Brian is a contributing columnist for SQL Server Standard and alsomaintains a weekly column for the database Web He is the author of Admin911: SQL Server(Osborne/McGraw-Hill Publishing) and coauthor of Professional SQLServer DTS and Professional SQL Server 2005 SSIS (WileyPublishing). Brian has spoken at such conferences as PASS, SQLConnections, and TechEd. His blog can be found

Allan Mitchell is joint owner of a UK-based consultancy,Konesans, specializing in ETL implementation and design. He iscurrently working on a project for one of the UK’s leadinginvestment banks doing country credit risk profiling as well asdesigning custom SSIS components for clients.

Darren Green is the joint owner of Konesans, a UK-basedconsultancy specializing in SQL Server, and of course DTS and SSISsolutions. Having managed a variety of database systems fromversion 6.5 onwards, he has extensive experience in many aspects ofSQL Server. He also manages the resource sites, as well as being a Microsoft MVP.

Douglas Hinson, MCP splits his time between database andsoftware development as a Senior Architect for Hinson &Associates Consulting in Jacksonville, Florida. Douglas specializesin conceptualizing and building insurance back-end solutions forpayroll deduction, billing, payment, and claims processingoperations in a multitude of development environments. He also hasexperience developing logistics and postal serviceapplications.

Kathi Kellenberger is a database administrator at BryanCave LLP, an international law firm headquartered in St. Louis,Missouri. She fell in love with computers the first time she used aRadio Shack TRS-80, many years ago while in college. Too late tochange majors, she spent 16 years in a health care field beforeswitching careers. She lives in Edwardsville, Illinois, with herhusband, Dennis, college-age son, Andy, and many pets. Her grown-updaughter, Denise, lives nearby. When she’s not working orwriting articles for, you’ll find herspending time with her wonderful sisters, hiking, cycling, orsinging at the local karaoke bar.

Andy Leonard is a SQL Server DBA, MCSD, and engineer wholives in Jacksonville, Florida. Andy manages a SQL Server DBA Team.He has a passion for developing enterprise solutions of all typesand a fondness for business intelligence solutions in industrialenterprises. Learn more at and reach Andy

Erik Veerman is a mentor with Solid Quality Learning andis based out of Atlanta, Georgia. Erik has been developingMicrosoft-based Business Intelligence and ETL-focused solutionssince the first release of DTS and OLAP Server in SQL Server 7.0,working with a wide range of customers and industries. His industryrecognition includes Microsoft’s Worldwide BI Solution of theYear and SQL Server Magazine’s Innovator Cup winner. Erik ledthe ETL architecture and design for the first productionimplementation of Integration Services and participated indeveloping ETL standards and best practices for IntegrationServices through Microsoft’s SQL Server 2005 referenceinitiative, Project REAL.

Jason Gerard is President of Object Future Consulting,Inc., a software development and mentoring company located inJacksonville, Florida ( Jason is an expertwith .NET and J2EE technologies and has developed enterpriseapplications for the health care, financial, and insuranceindustries. When not developing enterprise solutions, Jason spendsas much time as possible with his wife Sandy, son Jakob, andTracker, his extremely lazy beagle.

Haidong Ji, MCSD and MCDBA, is a Senior DatabaseAdministrator in Chicago, Illinois. He manages enterprise SQLServer systems, along with some Oracle and MySQL systems on Unixand Linux. He has worked extensively with DTS 2000. He was adeveloper prior to his current role, focusing on Visual Basic, COMand COM+, and SQL Server. He is a regular columnist, a popular and well-known portal for SQLServer.

Mike Murphy is a .NET developer, MCSD, and in a formerlife an automated control systems engineer currently living inJacksonville, Florida. Mike enjoys keeping pace with the latestadvances in computer technology, meeting with colleagues atJacksonville Developer User Group meetings ( and,when time allows, flying R/C Helicopters. To contact Mike, e-mailhim at or visit

Read More Show Less

Table of Contents




Who This Book Is For.

How This Book Is Structured.

What You Need to Use This Book.


Source Code.


Chapter 1: Welcome to SQL Server Integration Services.

Chapter 2: The SSIS Tools.

Chapter 3: SSIS Tasks.

Chapter 4: Containers and Data Flow.

Chapter 5: Creating an End-to-End Package.

Chapter 6: Advanced Tasks and Transforms.

Chapter 7: Scripting in SSIS.

Chapter 8: Accessing Heterogeneous Data.

Chapter 9: Reliability and Scalability.

Chapter 10: Understanding the Integration Services Engine.

Chapter 11: Applying the Integration Services Engine.

Chapter 12: DTS 2000 Migration and Metadata Management.

Chapter 13: Error and Event Handling.

Chapter 14: Programming and Extending SSIS.

Chapter 15: Adding a User Interface to Your Component.

Chapter 16: External Management and WMI Task Implementation.

Chapter 17: Using SSIS with External Applications.

Chapter 18: SSIS Software Development Life Cycle.

Chapter 19: Case Study: A Programmatic Example.


Read More Show Less

Customer Reviews

Average Rating 3
( 2 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted June 25, 2006

    Good But Not Great...

    I bought this book on the strength of the lead author's previous book on DTS. I have to say I'm somewhat disappointed. SSIS has become a teriffically more complicated albeit more powerful tool than DTS. Unfortunately, the way Wrox has chosen to deal with this complexity is by 'throwing more authors' at the subject. There are some great individual sections but on the whole this doesn't make up for the book's short-comings. There are key pieces of information that are flat out 'missing' (like the ProtectionLevel property of a package). For myself, I buy a book like this to find out as quickly as possible 'how to use the product'. I'm not especially interested in 'Software Development Life Cycles: A Brief History' - one of several sections in this book that should have been cut.

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Posted March 19, 2010

    Also good, but not great

    I found the content to be well-founded for professionals looking to get into SQL 2005 Integration Services (SSIS) for the first time. There was a fair amount of mention of previous SQL 2000 DTS, which was, in large, unnecessary. However, the Wrox Press methods of explaining and then demonstrating were as solid as ever. You'll find the mini-projects to be helpful, whether you are reading through or actually performing them. All things considered, this is a strong reference in my library.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)