I don't think you can do this simply in DTS, I've had a similar function to perform and had to use a package.

I loaded the data into a temp table,...