?
Solved

backup DTS local packages

Posted on 2002-07-08
1
Medium Priority
?
367 Views
Last Modified: 2013-11-30

I've used the "generated SQL script" wizard to generate sql script for my databases.  Is there a way to do this with DTS packages?

It would be nice to have a backup file of my DTS packages.

How can I do this?  I just want to make sure my DTS packages are backed up.

-k
0
Comment
Question by:gotaquestion
1 Comment
 
LVL 9

Accepted Solution

by:
miron earned 200 total points
ID: 7139157
if you ise sql server 2000 this will work,
navigate to the server's local packages, open package for design, in the pull down menu select item save as, in the "Location" drop down select "Structured Storage File" click save.

Cheers
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

831 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