Here is my two cents:

Whenever a system receives data from External sources, it is prudent to do a validation (sanity check) on the data before loading it to your production database.

I have not used the DTS service. Does it have this capability? If not, I think, you will be better off using a program as sbuckby did.

What do others say??

Ram