Post reply

Script to Save all DTS

  • February 7, 2003 at 1:40 am

    #80208

    Hi,

    I need to Archive out of my Sql Servers all the DTS. Unfortunatly I have more then 300 of DTS!!.

    So my question is, is someone as a script to easily script all the DTS in a single shot ?

    Thanks for you answers.

    Best regards,

    Michael.


    Best regards,

    Michael.

  • February 7, 2003 at 4:12 am

    #448348

    Another way you can do it is to a DTS package file.

    Saw this in another thread last night and started to script it to generate and run against all my DTS packages.

    textcopy /S ServerName /U sa /P /D msdb /T sysdtspackages /C packagedata /W "where name='DTSName'" /F DTSText.dts /O

    This command will bring package out as dts file. Then it can be opened from EM/open package.

    My thought was use a cursor for the packages table to get all the names, then loop thru it altering the string above and submit using xp_cmdshell. This should easily be able to output all in a hurry.

    If you write the code to loop thru and do this based on my suggestion and it works, please post to the scripts section for others to take advantage of in the future.

  • February 9, 2003 at 2:48 pm

    #448468

    Take a look at DTSBackup2000 at

    http://www.sqldts.com/default.aspx?6,105,242,0,0

    It has both GUI and Command line functionality. After making all your selections in the GUI you can generate a command line from your selections to include in a batch file for later execution.

    Thanks

    Phill Carter

    --------------------
    Colt 45 - the original point and click interface

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply