I was going to write a post stating that it was a great article, nicely written and really helpful for my daily routines. But luckily I've read the comments first.

Now...

Nice question. Thanks...

TravisDBA (9/9/2010)

---

In SQL Server 2008, the Resource database cannot...

After reading all the other comments, we can conclude that the question is flawed 🙂

You cannot move the resource DB in 2008, but apparently you can in 2005, so the...

Great, I was taking so long to formulate my answer, that two people were faster than me 🙂

Is the table in your post the starting point of your query, or is the result.

If it is the result, I guess you want to give some sort of sequence...

MRNev (9/8/2010)

---

Its possible though more longwinded as there are 10 or so lookups done and the way the original designer has done it, he does all the lookups and then...

Is it possible to set the NoMatchBehaviour to Redirect Rows to No Match Output?

This way you have your lookup failures in a seperate flow and there are no errors cause...

Are there any duplicates in your source?

Why don't you try to implement the SCD Type 1 yourself with an update and an insert statement. It will run a hell of...

Phil is right. Don't bother to make it dynamic if there are only a handful of Excel files. However, if there are a lot of Excel files (say more than...

Great question. I got it wrong, obviously, but I learned something.

Great article. It gives me a nice overview and a bunch of very useful links.

Now I just have to find the time to read them all 🙂

Phil Parkin (9/7/2010)

---

This all assumes that the invalid data can even get into your pipeline in the first place of course.

If you have appropriate datatypes already set up for your...

You do not have these functions out of the box in SSIS, in the sense that they are not present in the Derived Column Transformation.

However, if you read your source...

You need three components in your dataflow:

* Excel source (together with the Excel Connection Manager)

* Data Conversion component

* OLE DB Destination