Script find a DTS

• Joel Montero

  SSC Veteran

  Points: 219

  More actions

  December 3, 2008 at 9:59 am

  #71685

  Hello All;

  My server SQL Server 2000 broke down and was able to retrieve files from the master and msdb DB. When I try to restore the msdb mode is suspect. I did everything necessary to remove it from this state and remains unchanged. I want to move all the scripts that have the DTS. I already have the table where they are stored (sysdtspackage), packagedata field, but in binary mode. And find a program that converted to text for Binary and I do not bring results, just brings me an @.

  They can get help as the scrips of my DTS.

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  December 3, 2008 at 2:55 pm

  #907195

  Have you tried putting it in emergency mode? Do you have contents of sysdtspackages table with you?

  MJ