To all that might be able to help -

I was given a few DTS packages from a SQL 2000 server and need to import
them into one of my SQL servers, but I'm not sure how to go about that when
it is a .dts file. Can anyone help?

Hello Ern,

When you refer to importing the DTS packages I am assuming you mean
running them.

In SQL 2000 the easiest way to run a DTS package is form the
dtsrunui.exe

This utility will allow you to browse to the location of the DTS file
and execute the package.

DTSRUNUI will also generate a bat string that can be used in a SQL job.

If you need to edit a DTS file try the following:

1. Open Enterprise Manager
2. Select and Expand the database server
3. Right mouse click on Data Transformation Services folder
4. Select Open Package

Hope this helps

Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com/

Hello Big,

You can easily add them to the local packages on your sql server by opening
them in EM and then choose "Save As"

Allan

Ern,

MS hid this one really well. Fire up Enterprise Manager and connect to
the target SQL Server. If you want to open a .dts file in the DTS
Designer, right click on Data Transformation Services and click Open
Package. Then you can do the Package->Save As to get the package into
your SQL Server.

Norman

get DTS Package Search at http://www.gerasus.com/

Big Ern wrote: