Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to Export DTS Package? Expand / Collapse
Author
Message
Posted Saturday, September 3, 2005 5:30 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, January 18, 2007 9:35 PM
Points: 62, Visits: 1

Hi,

I have created one DTS Package and saved as DTS Package as SQL Server Local Package.

Now I want to Export this package into another Database.

How can I do this?

Please help, I am new to SQL Server...

 




Kindest Regards,

Vishal Prajapati

DBA at Extentia Infromation Technology

Post #216817
Posted Sunday, September 4, 2005 5:16 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, November 16, 2014 6:41 PM
Points: 2,693, Visits: 1,219

Many ways to achieve this, try each and pick one that suits your need best. Also, be aware that depending on how you've designed your package you may need to edit it on the new server to change servernames, filenames, etc...

1) Edit the package in Enterprise Manager and choose Save As...
2) Transfer the rows from sysdtspackages as explained here (http://www.sqldts.com/default.aspx?204)
3) Use a tool like DTSBackup2000 (http://www.sqldts.com/default.aspx?242)

 



Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface

Australian SQL Server User Groups - My profile
Phills Philosophies
Murrumbeena Cricket Club
Post #216880
Posted Wednesday, September 7, 2005 10:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 9:37 PM
Points: 8, Visits: 273
Vishal,
A very simple way, as Phill mentioned, is to 'Save As' and select structured storage file.
On the 2nd server, right-click DTS and select 'Open Package' and select the saved file. Make the any necessary changes and you SHOULD be good to go.
Post #217704
Posted Wednesday, March 1, 2006 2:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 1, 2006 2:22 AM
Points: 2, Visits: 1
In my case, I developed a DTS system contains 40 DTS packages, If I use the way that you said above it will take me a lot of time and effort.
I write a simple program in VB to transfer DTS from one database to another, it works well. But when I save DTS to storage files and after that, I import DTS in to SQL Server and all DTS's layout has changed.
Any one here know which way to import DTS and their layout are not changed?
Thank you in advance.
Post #262201
Posted Wednesday, March 1, 2006 2:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 1, 2006 2:22 AM
Points: 2, Visits: 1
In my case, I developed a DTS system contains 40 DTS packages, If I use the way that you said above it will take me a lot of time and effort.
I write a simple program in VB to transfer DTS from one database to another, it works well. But when I save DTS to storage files and after that, I import DTS in to SQL Server and all DTS's layout has changed.
Any one here know which way to import DTS and their layout are not changed?
Thank you in advance.
Post #262202
Posted Wednesday, March 1, 2006 3:09 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, November 16, 2014 6:41 PM
Points: 2,693, Visits: 1,219

If you're saving the packages outside of SQL Server, or modifying them programmatically, then you will lose the layout and all text annotations. This is because these items are not part of the DTS object model.

If you're transferring packages between SQL Servers and have network connectivity, then checkout the DTSBackup2000 tool I mentioned in my earlier post. The tool has an option to transfer the packages and keep the layout and annotations intact.

 



Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface

Australian SQL Server User Groups - My profile
Phills Philosophies
Murrumbeena Cricket Club
Post #262211
Posted Wednesday, March 1, 2006 12:44 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 11:35 AM
Points: 260, Visits: 205

Vishal,

Send me a personal message with your email address than can accept an attachment.  I have written a utility that will compare as well as transfer dts packages between two different servers.  It avoids the need to manage any type of storage or backup files.  I believe this is exactly what you are looking for.  I wrote this utility to keep a dev and production environment in sync, containing over 80 packages.  I would be happy to send it to you if you think it would help you solve your problem.

-Mike Gercevich

Post #262465
Posted Wednesday, March 1, 2006 1:02 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, January 18, 2007 9:35 PM
Points: 62, Visits: 1

Hi,

Thankz mike for you reply.... Please send me utility.... It will really help me....

Please send me at vishu_prajapati@yahoo.co.in

Thanking




Kindest Regards,

Vishal Prajapati

DBA at Extentia Infromation Technology

Post #262474
Posted Friday, August 24, 2007 2:36 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, August 25, 2014 10:32 AM
Points: 36, Visits: 211
Many Thanks for "philcart" for location of DTSBackup2000. It's exactly the tools I need. Save & restore basically three DTS is easy and fast, but when you have about fourty to do, it will be boring...
So, I'm happy :o)
Post #393583
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse