posted on Saturday, January 21, 2006 11:52 PM by bknight

Professional SQL Server 2005 Integration Services Finally Ships!

Whew, what a long road but our book is finally being shipped to bookstores and out from Amazon this week. The book is a tutorial fashion book for SSIS and you can download one of the chapters in PDF format below. 

* - Buy the book on Amazon.
* - Download Chapter 5 - Creating an End-to-End Package

-- Brian Knight

Comments

# re: Professional SQL Server 2005 Integration Services Finally Ships!

Monday, January 30, 2006 11:10 AM by Amit
Have just gone through sample chapter and elaboration is awesome. Have ordered the book. Cant wait to read other chapters.

One question: Have you covered scenario where one may want to modify the source record itself as part of SSIS destination? e.g. simple scenario could be..

1. Read ADDRESS record A1 from table T1
2. Use A1.ZipCode to make external WebService call to fetch complete address information including addresslines, city, state, country.
3. Update the SAME A1 with these values

These will be frequent data cleansing operations where you really dont want to create new table to store cleansed data.

I would appreciate if you can post some sample to address such scenarios.

# re: Professional SQL Server 2005 Integration Services Finally Ships!

Monday, February 06, 2006 5:57 PM by Brian Knight
Great example Amit. We do cover the Web Service task but it's a bit different than what you're looking for since you want to do such a lookup in the pipeline. Such a lookup can be done through a Script Transform (Component) which we do cover pretty extensivily. Let me work on a demo of a transform like that and I'll post it here as soon as I'm done.

# re: Professional SQL Server 2005 Integration Services Finally Ships!

Monday, March 06, 2006 1:10 PM by Wes Dumey
Brian: Great book, it's very helpful for understanding SSIS.

# re: Professional SQL Server 2005 Integration Services Finally Ships!

Tuesday, March 18, 2008 7:18 AM by zxevil163
4ZYv4D Hi from Russia!