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