This content is not currently approved and is visible here for review only.

Microsoft SQL Server 2008 Integration Services Unleashed

Microsoft SQL Server 2008 Integration Services Unleashed
Authors
Kirk Haselden
ISBN
0672330326
Published
08 Feb 2009
Purchase online
amazon.com

Microsoft SQL Server Integration Services is Microsoft’s powerful platform for building enterprise-level data integration and data transformation solutions. It’s a powerful product, but it’s also complex and can be confusing if you don’t have a clear map for the journey. Microsoft SQL Server 2008 Integration Services Unleashed will be the only book you’ll need to harness the power that Integration Services provides.

Page 2 of 2
  1. Editorial Reviews
  2. Customer Reviews

Customer Reviews

Guillermo J. Caicedo said
En el libro SQL Server 2008 Integration Services, Kirk Haselden hace un buen trabajo al proveer una basta explicación de principio a fin de lo que es Integration Services y para que utilizarlo. El autor utiliza una gran cantidad de ejemplos que están disponibles para bajar en la página del libro ([...]) para demostrar sus conceptos.

Hasta los lectores con menos experiencia o que se estén moviendo de DTS a SSIS encontraran una clara explicación de la nuevas funcionalidades existentes en SQL Server 2008 (como mejoras al "Data Flow Task", mejor experiencia en la creación de Scripts en VB y C#, "Data Profiling Task", etc...)

El autor nos lleva desde la instalación, mejores prácticas de la migración de DTS a SSIS, los conceptos básicos de SSIS, creación de packetes, manejo de variables y manejo de eventos hasta el desarrollo de componentes "custom" en el caso de que los componentes que son incluidos con SSIS no cumplan con las necesidades del usuario.

El libro está escrito de una forma en que cada capítulo puede ser leído independientemente de los otros y por lo tanto es buen libro de referencia.

Algo que personalmente encuentro que es muy bueno es que los ejemplos que utiliza el autor son ejemplos que pueden ser aplicados directamente al área de trabajo sin muchas modificaciones.

Este definitivamente debería ser un libro para su colección de libros de bases de datos.

----------------------------------------------------------------------------------------

In the book SQL Server 2008 Integration Services, Kirk Haselden makes a good job in providing good explanation from start to finish of what Integration Services is all about and when it should be used. The author uses good examples that are available for download at the books website ([...]) to prove his concepts.

Even the least experienced readers or the ones that are moving from DTS to SSIS will find a clear explanation of the new features in SSIS 2008 (like improvements to the Data Flow Task, better scripting experience VB and C#, Data Profiling Task, etc...)

The author takes us from the installation, DTS to SSIS best practices, SSIS basics, package creation, variables, error handling, to the development of custom components.

The book is written in such a way that each chapter can be read independently of each other and for that reason makes a good reference book.

Something that I personally like is that it provide good examples that with little modification con be applied your work area.

This would be a good book to add to your db books collection.

W Boudville said
There's a small irony here. As Microsoft has vastly built up its SQL Server, the complexity of understanding and using it has concomitantly risen. Which in turn has led to the features discussed at length in the book. These broadly try to help you grasp the many parts of SQL Server. But the very heft of the book suggests that things are still non-trivial.

One message across the chapters is that the task user interfaces are as similar as can be, to ease learning. There are also various connection managers that handle reading or connecting to data of different formats, or to different types of data servers. So you don't waste your time on low level tasks of "impedance matching". At the simplest level, there is a Flat File Connection Manager, for reading a flat file of tabular data. This might be CSV or fixed width. Other connection managers go out on the network to get ftp files, or files with an HTTP address.

The amount of actual programming has been deliberately minimised. This is another pervasive theme of the book. To the extent that you do have to [or want to] program, it is at the scripting level. The example scripts do not seem difficult, but this opinion may vary as a function of your background.

Potentially the highest value aspects of the Integration Services concern Business Intelligence. This term is used in various places throughout the book, which does advise you that the term spans a "broad and deep field". Essentially, think of it as Artificial Intelligence in a business analysis context. Be aware that the BI aspects are very rudimentary. [Don't get your hopes up.] There are some neat little tools, like a Slowly Changing Dimension Wizard and data cleansers. Useful, and it's good that Integration Services has them. But they handle relatively low level issues.

You might also like...

Comments

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Nine people can't make a baby in a month.” - Fred Brooks