As Sabya suggested, please read up on the SCD component and then post back with any additional questions.

You chose ... wisely.

Could the column names in the external text file be changing?

a.hadss (12/30/2009)

---

see this is what i hav...

in the database:

table one: Customer(ID, Name, Age, Location_ID)

table 2: Location(ID, LOC_NAME)

in a datawarehouse:

table 1: Cust(ID, Name, Age, Location_Name)

now i want to refresh the dataware...

Use a Conditional Split and send the unwanted row(s) to an output which goes nowhere ...

A possible alternative is to delete and recreate the sheet you are working with, using Execute SQL tasks against an Excel Connection Manager connection ...

DROP TABLE 'sheetname'

followed by

CREATE TABLE 'sheetname'...

Aggregation can remove dups too. But it all works faster using the database engine, as already noted.

This is really not my area of expertise, but I think that you'll have no problems with the availability of regedit and that gacutil would be installed as part of...

Not really. Still seems like a versioning issue to me. Did you have to register that DLL on your local PC, or was it just 'there' as a result of...

What does the Script Task do?

But version 10, as referred to in your error message, is Excel 2002 (see here).

At what point is the error message appearing? Is it when you try to run the...

Version 10 is Excel 2002, I think. Is that what you have on your PC? You need to get these versions in order ...

So ......

Does the server have Excel installed?

Sabyasm told you already - what is wrong with that method?