Would it be possible to write a vb application that:
Reads all the SQL 2000 DTS pakages on a server saved at location SQL Server.
Save them as VB projects.
Loops through the saved VB projects and reset global variables that relate to database connectivity.
Want to automate moving packages from production to test.