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
You must unlearn what You have learnt