• 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


    You must unlearn what You have learnt