Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


How to backup the local packages in Data Transformation Services

Posted on 2007-10-05
Medium Priority
Last Modified: 2008-01-09
I have quite a number of local packages in Data Transformation Services for SQL Server 2000.
How can I backup  and restore the packages?
Question by:sepknow
  • 3
  • 2
LVL 25

Expert Comment

ID: 20020128
DTS -info is stored in the MSDB-database so the backup of that database contains the packages

Author Comment

ID: 20020178
I tried to restore for development server but keep getting error saying the databse is in use but there are no other user and the database is not lock. Any advice?
LVL 25

Accepted Solution

jogos earned 1000 total points
ID: 20020360
That's a whole other question, you want to get your packages on another server .I remember you can save a DTS package as VBS-project. But I didn't ever tried to 'export' the whole bunch at once

restore Msgb
Your backup-info is stored in the msdb-db also so it could block itself. Your backup-info will be lost too!

Author Comment

ID: 20020380
I did asked for both backup and restore and
I am trying to restore on the same server. Its just that I am trying on the development server by deleting few packages and trying to restore from backup...
LVL 25

Expert Comment

ID: 20021259
'Backup and restore' as I earlier mentiont is of th MSDB-db. But there are also other things kept so know what you are doing! Because MSDB-db holds also information about backups it's not so weird getting a message 'database in use'. Problem also treated in earlier mentioned link.

If you look for a pure DTS-approach there is some tool like a DTSBAckup

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question