July 17, 2001 at 12:00 am
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sjones/recoverthosepackages.asp
August 13, 2001 at 7:11 am
... " 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
August 13, 2001 at 2:14 pm
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
January 27, 2003 at 10:08 am
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.
[font="Tahoma"]Bryant E. Byrd, BSSE MCDBA MCAD[/font]
Business Intelligence Administrator
MSBI Administration Blog
January 27, 2003 at 11:34 am
Sorry for the typo, but glad we got you pointed in the right direction.
Steve Jones
July 12, 2005 at 1:51 pm
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.
July 29, 2005 at 12:53 pm
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
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply