DTS to run other DTS's

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Chris (anonymous_at_devdex.com)
Date: 04/07/04 

Date: Wed, 07 Apr 2004 03:40:54 -0700

I have created 23 DTS packages to transfer data from an other database
into SQL server. Rather than schedule each of these I would like to
create one more package that runs all the others.

Is this possible and if so how do I set it up.

Thanks

Chris
North Cotswold Computing

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • RE: Where are my DTS packages
    ... Your DTS packages in your case are most likely stored in the msdb database. ... If you can get a copy of the old msdb database and restore this you will be ... > SQL Server was lost although the DATA was held on another drive. ...
    (microsoft.public.sqlserver.dts)
  • Re: Moving DTS to new server
    ... you can save the DTS packages as "Structures Storage File" and then open ... these files on your new database and save it in the SQL Server. ...
    (microsoft.public.sqlserver.replication)
  • Re: Need help with DTS Package Maintenance
    ... You can create DTS packages in VB, ... > source Interbase Database and I make a SQL Server connection to the target ...
    (microsoft.public.sqlserver.dts)
  • Re: Standard Method for Importing/Exporting to DB
    ... the database name, server name, and filename+fullpath. ... and also exporting to CSV files. ... everything from DTS packages to Crystal Reports are used. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: How do I distribute DTS Packages with my Application Database?
    ... BTW, is there any way to store a DTS package in a specific *database*, as ... And if not possible with SQL Server ... > Number of ways but undoubtedly the easiest is as a Structured Storage file ... >> distribute my DTS Packages? ...
    (microsoft.public.sqlserver.dts)