Click here to Skip to main content
12,556,221 members (57,270 online)
Click here to Skip to main content
Add your own
alternative version


24 bookmarked

Move DTS Package from one MS SQL Server to another

, 31 May 2006
Rate this:
Please Sign up or sign in to vote.
Do you know the easiest way to move DTS package from one SQL server to another? The answer is here.


You developed a DTS package. Now you want to move to live SQL sever. you might wondering what the easiest way is to move DTS from you local SQL Sever to the remove SQL Server.

There are serveral ways to move, but I tell you the easiest one.

1. Save your existing DTS Package as a Structure Storage File, lets assum it is called t.dts

2. Copy t.dts to destination Microsoft SQL Server

3. Open Destination SQL server Enterprise Management.

4. Right click data transformation service

5. select open a package

6. After you opened the package, click "Package" -> select "Save as..." to save as SQL Server.

The step by step sreen shoots is attached.



This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


About the Author

Haiyan Du
Software Developer (Senior) Telvent Farradyne Inc.
United States United States
Leading .NET developer, System Archetect on GIS, CMS, and Cloud Computing System
skills on:
SQL Server, My SQL, Access, Oracle, and IBM AS400, DB2

ASP.NET, HTML, ASP, Style Sheet and XSLT, XML
, ADO. Net, COM+ and Web Service, Crystal Report, Transaction-SQL, DTS Procedure, Windows Form/WPF,WCF, WF

Programming Language: C#, vb.NET, VBScript, JavaScript

You may also be interested in...


Comments and Discussions

Generalthis is so helpful Pin
Marianne Seggerman23-May-11 5:58
memberMarianne Seggerman23-May-11 5:58 
GeneralMy vote of 5 Pin
Marianne Seggerman23-May-11 5:57
memberMarianne Seggerman23-May-11 5:57 
GeneralMy vote of 5 Pin
sky2nui13-Jul-10 2:42
membersky2nui13-Jul-10 2:42 
GeneralNo Demo Pin
Malik Nasir31-May-06 19:05
memberMalik Nasir31-May-06 19:05 
GeneralRe: No Demo Pin
Haiyan Du1-Jun-06 3:56
memberHaiyan Du1-Jun-06 3:56 
GeneralSorry for misspell Pin
Haiyan Du31-May-06 10:00
memberHaiyan Du31-May-06 10:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.161021.1 | Last Updated 31 May 2006
Article Copyright 2006 by Haiyan Du
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid