Glad it worked out for You.

For data manipulation / cleaning I always use SQL.

In DTS, if I use it, I put as little business logic as possible, if any.

The staging table approach is very efficient and fault proof.

*sql/bulkinsert/dts/bcp **SQL

DirtySource ->* StageTable --cleanvalidatelogerrors-->** ProductionTable

/rockmoose