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

Recover Those Packages! Expand / Collapse
Author
Message
Posted Tuesday, July 17, 2001 12:00 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 2:28 PM
Points: 33,062, Visits: 15,174
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sjones/recoverthosepackages.asp






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #603
Posted Monday, August 13, 2001 7:11 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 5:51 AM
Points: 6,266, Visits: 2,028
... " The drop down for the destination of the Transform Data Task doesn't display the system tables"

Comment:
If you are using DTS 2000, BEFORE you select the tables on your Transform Data Task, you can use the DISCONECTED EDIT feature to fill in a system table name !!!

Noel Diaz
DBA
Implex Corp.



* Noel
Post #20165
Posted Monday, August 13, 2001 2:14 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 2:28 PM
Points: 33,062, Visits: 15,174
Noel,

Outstanding!!!! I didn't know this.

Thanks for the info.

Are you interested in writing a short "Transferring System Tables" article? If not I will, but it's a great topic.


Steve Jones
steve@dkranch.net







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #20166
Posted Monday, January 27, 2003 10:08 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 7, 2014 12:50 PM
Points: 292, Visits: 264
I tried this on my installation of SQL Server 2000 (SP2 plus security patch 061) and it couldn't find the table. It turned out that the table name in the query was incorrect but got me pointed in the right direction. The corrected script is as follows:

insert msdb.dbo.sysdtspackages
select * from msdb_temp.dbo.sysdtspackages

Thanks for the help!

Bryant E. Byrd, MCDBA
SQL Server DBA/Systems Engineer
Intellithought, Inc.
bbyrd@intellithought.com


Bryant E. Byrd, BSSE MCDBA MCAD
Business Intelligence Administrator
MSBI Administration Blog
Post #20167
Posted Monday, January 27, 2003 11:34 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 2:28 PM
Points: 33,062, Visits: 15,174
Sorry for the typo, but glad we got you pointed in the right direction.

Steve Jones
sjones@sqlservercentral.com
http://www.sqlservercentral.com/columnists/sjones
www.dkranch.net







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #20168
Posted Tuesday, July 12, 2005 1:51 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, May 29, 2008 7:11 AM
Points: 44, Visits: 3

Steve ... the typo was minor, 1 minute annoyance in comparision to the grief I was suffering trying to remember ALL of the DTS packages I had. I too, did exactly what you did above ... and I consider myself painstainkingly anal about backups and the like. Go figure!

Thanks for the tip - it saved my trip.

 

Post #200191
Posted Friday, July 29, 2005 12:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 18, 2005 2:55 PM
Points: 1, Visits: 1
Yes, this is very helpful. Thanks!
But I understand this isn't the "right" way to recover DTS packages, if you start out with a backup of it?
I am not able to see the link for "Save a DTS Package Locally" in your article. Can you send the link again if it still exists?

If you are copying over a whole instance to a different server, how do you transfer over the DTS packages in msdb? MSDB can't be detached.

Thanks!
kd
Post #205765
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse