How to import the *.DTS file in SQL Server 2000

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ankush Arakere Choudera SSC Enthusiast Points: 154 More actions · Answer 1

hi Prashanth,

below are the steps for importing a DTS package.

Open Enterprise Manager - Client.

- Right click on the Data Transformation Services Folder.

- Select Open Package and browse through your local system folders to select the *.DTS file and open it.

Thats all.. you have that DTS package on your Server.

Regards,

Ankush

mdaniel SSCarpal Tunnel Points: 4616 More actions · Answer 2

After opening the DTS like ankushac said, you have to save it on the server:

- Select Save as... from the Package menu

- Change the location to SQL Server

- Select your server and user/password

Tom Hamilton-126456 Mr or Mrs. 500 Points: 527 More actions · Answer 3

It sounds like you want to import a *.DTS file. If that's the case then:

1) Open SQL Server

2) Click on Data Transformation Services

3) Click on Action on the Menu Bar

4) Select 'Open'

5) Browse to and Open the DTS Package file

Hope this helps:

Peter Evans Ten Centuries Points: 1187 More actions · Answer 4

You might also try the DTSRUN.EXE tool. IIRC, It doesn't require you to have EM to run a package.

Peter Evans (__PETER Peter_)