I think you're losing speed in the DTS/ASP/Perl mess. It's easy enough to dump a SQL Server table to a text file. Use that as the input for the Perl script. Write the output in the same format and use BULK INSERT to load it into the table. Half an hour learning these two steps will save a a lot of the time spent pushing records through DTS/ASP. Even 1 million records times 400 bytes is only 400Mb, so disk space for the text files shouldn't be a problem.

---
Spring: Forces, Coiled Again!