How to import DTS Package from disk

It's easy, but the option is really hard to find.

Right-click "Data Transformation Services" under the server/instance name in Enterprise Manager, and choose Open Package. Point it to your .DTS file and open it. Then choose Package menu, Save As, change type from structured storage to SQL Server, then enter your server/instance and login. That's it.

Source: Peter Johnson, aspsqlserver2000
Viewed 7920 times