"chriske911" <chriske911nospam@yahoo.com> wrote in message
news:mn.d3aa7d58d9aa719e.36062@yahoo.com...

"chriske911" <chriske911nospam@yahoo.com> wrote in message
news:mn.eab67d58732f088c.36062@yahoo.com...
>> You could do this a number of ways but one of them might be to export
>> sysdtspackages to a text file every night and save that off somewhere.
>>
>> "chriske911" <chriske911nospam@yahoo.com> wrote in message
>> news:mn.ea267d58e397dfc8.36062@yahoo.com...
>>>>
>>>
>>> thnx, found it eventually on this site:
>>> <http://www.sqldts.com/default.aspx?204>
>>>
>>> and completed the restore succesfully
>>>
>>> next question maybe is how to perform an automated backup for DTS
>>> packages only
>>> so not the complete msdb data file
>>>
>>> grtz
>>>
>>>
>
> can I use this backup txt files to import it into another server?
> as far as I can see the records in the sysdtspackages table are binary
> how can I make a file out of these records?
>
> thnx
>
>

"chriske911" <chriske911nospam@yahoo.com> wrote in message
news:mn.ea267d58e397dfc8.36062@yahoo.com...
>> Was your colleague saving the dts package to SQL Server? If so, the
>> package
>> data can be found in the sysdtspackages table of msdb database. Do you
>> have
>> a recent msdb backup or msdb data and log files available?
>> --
>> HTH,
>> Vyas, MVP (SQL Server)
>> SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
>>
>> "chriske911" <chriske911nospam@yahoo.com> wrote in message
>> news:mn.d3aa7d58d9aa719e.36062@yahoo.com...
>> is there a procedure for recovery of dts packages of a crashed server?
>> I have a colleague who was developping a dts package on a test server
>> off course, the inevitable happened without a backup at hand
>>
>> where can I find the DTS packages and how can I get them back
>>
>> PS: it was a diskcrash with a corrupt MFT and some bad blocks
>> file recovery from the disk is still possible for the moment
>>
>> thnx
>
> thnx, found it eventually on this site:
> <http://www.sqldts.com/default.aspx?204>
>
> and completed the restore succesfully
>
> next question maybe is how to perform an automated backup for DTS packages
> only
> so not the complete msdb data file
>
> grtz
>
>

> Was your colleague saving the dts package to SQL Server? If so, the package
> data can be found in the sysdtspackages table of msdb database. Do you have
> a recent msdb backup or msdb data and log files available?
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
>
> "chriske911" <chriske911nospam@yahoo.com> wrote in message
> news:mn.d3aa7d58d9aa719e.36062@yahoo.com...
> is there a procedure for recovery of dts packages of a crashed server?
> I have a colleague who was developping a dts package on a test server
> off course, the inevitable happened without a backup at hand
>
> where can I find the DTS packages and how can I get them back
>
> PS: it was a diskcrash with a corrupt MFT and some bad blocks
> file recovery from the disk is still possible for the moment
>
> thnx

> You could do this a number of ways but one of them might be to export
> sysdtspackages to a text file every night and save that off somewhere.
>
> "chriske911" <chriske911nospam@yahoo.com> wrote in message
> news:mn.ea267d58e397dfc8.36062@yahoo.com...
>>>
>>
>> thnx, found it eventually on this site:
>> <http://www.sqldts.com/default.aspx?204>
>>
>> and completed the restore succesfully
>>
>> next question maybe is how to perform an automated backup for DTS packages
>> only
>> so not the complete msdb data file
>>
>> grtz
>>
>>