Click here to Skip to main content
Click here to Skip to main content
Go to top

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.

Introduction

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.

 

License

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

Share

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

Comments and Discussions

 
Generalthis is so helpful PinmemberMarianne Seggerman23-May-11 5:58 
GeneralMy vote of 5 PinmemberMarianne Seggerman23-May-11 5:57 
GeneralMy vote of 5 Pinmembersky2nui13-Jul-10 2:42 
GeneralNo Demo PinmemberMalik Nasir31-May-06 19:05 
GeneralRe: No Demo PinmemberHaiyan Du1-Jun-06 3:56 
GeneralSorry for misspell PinmemberHaiyan Du31-May-06 10:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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 | Mobile
Web02 | 2.8.140926.1 | Last Updated 31 May 2006
Article Copyright 2006 by Haiyan Du
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid