Like somuch.com on Facebook Share somuch.com on Facebook somuch.com on Twitter Reddit LinkedIn Pinterest
Newest Tips & Tricks...

Home :: Tips & Tricks :: Microsoft SQL Server

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

Recommended Links...