SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Copying/backing up DTS Packages
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

mdhingra01
Posting Yak Master

Canada
179 Posts

Posted - 04/27/2004 :  10:39:31  Show Profile  Reply with Quote
Thanks for all the help guys. I was googling and found this site which helped explain the route you all were suggesting. There is also a free tool for download called DTSBackup. Its very easy to use

http://www.sqldts.com/default.aspx?204

Cheers.
Go to Top of Page

SQLCode
Posting Yak Master

USA
143 Posts

Posted - 04/29/2004 :  09:43:30  Show Profile  Reply with Quote
Like Tara said in her first post ( I never missed seeing it earlier too) can this not be done by just the export of sysdtspackages table in msdb database?
for future use, the back up of just the table can be stored in a temp table or in an excel sheet and then restored to the sysdtspackages table of the destination server if there are concerns for restoring the whole database (msdb).
Or is there any reason why we need the whole db backed up that I am missing?
Pls. enlighten.

Also, there is this very useful site and deals with transfering DTS packages.
http://www.sqldts.com/

TIA.
Go to Top of Page

SQLCode
Posting Yak Master

USA
143 Posts

Posted - 04/29/2004 :  09:49:17  Show Profile  Reply with Quote
Oops, didn't see the page 2 of this post. Good you found the site.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36984 Posts

Posted - 04/29/2004 :  12:19:28  Show Profile  Visit tkizer's Homepage  Reply with Quote
quote:
Originally posted by SQLCode

Or is there any reason why we need the whole db backed up that I am missing?
Pls. enlighten.




MSDB is a system database that needs to be backed up regularly. It does not only contain DTS packages. It also contains your jobs, operators, and alerts (jobs being the most important).

Tara
Go to Top of Page

coolerbob
Aged Yak Warrior

United Kingdom
841 Posts

Posted - 03/21/2005 :  05:58:25  Show Profile  Reply with Quote
SQLCode, did you ever try your suggestion of importing the dtspackages from an excel sheet?
Go to Top of Page

Andyyy
Starting Member

United Kingdom
2 Posts

Posted - 03/07/2007 :  04:34:32  Show Profile  Click to see Andyyy's MSN Messenger address  Reply with Quote
Hi,
Just a quick post on this topic. Did you try running the package in Query Analyser like this:
usp_SavePackages 'E:\DTSBACKUPS\'
the \ at the end of the folder name is essential to the code working. If you run it like this:
usp_SavePackages 'E:\DTSBACKUPS'
then the folder is created, but no files are exported into the folder.
I ran the script as i showed in the first example and it worked perfectly first time.
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000