Re: Local DTS Packages Backup?-Thanks

From: Don Miller (nospam_at_nospam.com)
Date: 04/30/04

  • Next message: Sam: "Re: Help!local DTS package scheduling Error!" 
    Date: Fri, 30 Apr 2004 14:17:49 -0500

    Thanks, that's what I was looking for.

    "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
    news:uEazFUuLEHA.620@TK2MSFTNGP10.phx.gbl...
    > Using your standard SQL Server backup routine if you save your packages to
    > SQL Server then backing up msdb will do it for you.
    >
    > Also look to this
    >
    > DTSBackup 2000
    > (http://www.sqldts.com/default.aspx?242)
    >
    > --
    > --
    >
    > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
    > www.SQLDTS.com - The site for all your DTS needs.
    > I support PASS - the definitive, global community
    > for SQL Server professionals - http://www.sqlpass.org
    >
    >
    > "Don Miller" <nospam@nospam.com> wrote in message
    > news:OLaFDFuLEHA.140@TK2MSFTNGP09.phx.gbl...
    > > How do you reliably backup local DTS packages on a server?
    > >
    > > I know you can save each package separately as a package or VB file
    > > somewhere that does get backed-up but that certainly requires someone to
    > > ALWAYS save a backup whenever any package is tinkered with. Is there an
    > > easier way?
    > >
    > > Thanks.
    > >
    > >
    >
    >

  • Next message: Sam: "Re: Help!local DTS package scheduling Error!"

    Relevant Pages

    • Re: Can you use osql in DTS?
      ... This sounds simple enough to do in a single package. ... ActiveX Script task to build the date and time strings to populate the ... Data Pump task that executes a proc that populates a table and then ... Columnist, SQL Server Professional ...
      (microsoft.public.sqlserver.dts)
    • Re: Can you use osql in DTS?
      ... This sounds simple enough to do in a single package. ... ActiveX Script task to build the date and time strings to populate the ... Data Pump task that executes a proc that populates a table and then ... Columnist, SQL Server Professional ...
      (microsoft.public.sqlserver.programming)
    • Re: Migrating DTS Local Package from test to production environments v7.0
      ... The version of SQL Server on which the package was create is SQL Server ... DTS runs at the client so manually will be on the invoker's PC which in this ...
      (microsoft.public.sqlserver.dts)
    • RE: Migrating DTS to Integration Services
      ... let me answer your Encryption issue when you expand your MSDB ... used to connect to your SQL Server, ... Open services.msc and restart your SQL Server Integration Service. ... Migrate DTS 2000 packages or Add Existing package (since you have migrated ...
      (microsoft.public.sqlserver.dts)
    • Re: Local DTS Packages Backup?
      ... Using your standard SQL Server backup routine if you save your packages to ... SQL Server then backing up msdb will do it for you. ... > How do you reliably backup local DTS packages on a server? ... > I know you can save each package separately as a package or VB file ...
      (microsoft.public.sqlserver.dts)
    Loading