Actually, if you install ActivePerl, you can use PerlScript with DTS in any of the places where you normally would use VBScript. I've been using it quite successfully with DTS in SQL Server 2000, and it's an immense improvement over VBScript (obviously). It also appears to be available in SQL Server 7, although I haven't actually used it with that version.

In fact, if you execute the packages from your client machine, then I believe that ActivePerl only needs to be installed on the client, not the server. However, if you want to schedule any jobs which run on the server, then it needs to be on the server, as well.