1. Document current functionality of existing dts packages.

2. Write stored procedures to duplicate functionality.

Of course, it may be easier to recreate the dts packages as ssis packages, not stored procedures.