Thursday, July 14, 2005 - Posts

SSIS syntax in a derived column expression

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS syntax in a derived column expression
The new RSS feed is here

Ok So in the picture of my last post I had a Derived Column. This was to see if having a single field with the address in changed the fuzzy lookup. So I add a derived lookup to concatenate the field

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS syntax in a derived column expression

posted Thursday, July 14, 2005 9:00 AM by SimonSabin with 0 Comments Rated Good [4 out of 5].

SSIS Performance

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS Performance
The new RSS feed is here

You might have gathered I've been using SSIS. One of the reasons is that it is usable. Let me explain. Previously I had Feb CTP I think installed, an old one anyway. and it took an age for the debugger to fire up and shut down. This meant developing was very very slow.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS Performance

posted Thursday, July 14, 2005 7:20 AM by SimonSabin with 0 Comments

SSIS One step further

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS One step further
The new RSS feed is here

So I've done my addresses, but what about my companies.

Well its easy.

  1. Add another connection to get your companies
  2. Add a fuzzy lookup on the company name of that
  3. Sort the data (need to sort if your going to merge) by company key
  4. Send to a merge operation
  5. Add another sort
  6. Join the Source of addresses to the second sort, and select the company key to sort on
  7. Join Both sorts to the merge
  8. The Merge infers the join by the sort keys
  9. Join the merge back to the fuzzy lookup for addresses
  10. Press F5

So now I am de-duping companies, then merging this data with the addresses, and deduping the addresses by company and addres and outputing the results. Without 1 single line of code.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS One step further

posted Thursday, July 14, 2005 4:21 AM by SimonSabin with 0 Comments