I have a .DTS extension file from different server in my C drive how do I
import it to view the contents int he current server.

In Enterprise Manager

--2000
Right Click on the Data Transformation Services Folder | Open Package

--7
Right Click on the Data Transformation Services Folder | All Tasks | Open
Package


--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Anup" <anup_pokhrel (AT) hotmail (DOT) com> wrote

From in Enterprise Manager, right click on the Data
Transformation Services node and select Open Package. You
can then select the package from the Select File window.
After opening the package you can save it to the server by
going to the menu in the package designer window and select
Save As and for location, select SQL Server.

-Sue

On Mon, 21 Jun 2004 17:02:56 +0545, "Anup"
<anup_pokhrel (AT) hotmail (DOT) com> wrote: