Re: several steps in a dts package

1. You can have may tasks in a DTS package, even running in parallel, if
you so choose.
2. DTS packages can run ActiveX VBScript tasks. They can even run .EXE's
via an Execute Process task. The Execute SQL task can run a stored proc.
3. You can schedule a DTS package. Once you save it, right-click on it an
select Schedule package. Packages can execute other packages. SQL Agent
job steps can run conditionally.
4. In SQL 2005, you have SQL Server Integration Services (SSIS).

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com

"Wendy Elizabeth" <WendyElizabeth@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:4A9BE740-61A5-4D60-9E4D-82C2BB157D50@xxxxxxxxxxxxxxxx
>I just started a position where a person at this company submits file pulls
> from different sql server 2000 databases in lots of ways. This person does
> not have anything setup in steps like using a dts package.
> Thus I have the following questions about setting up DTS packages:
> 1. Can a dts package have lots of steps to it? I know that if I put "GO"
> statements
> between several sql statements while runinng query Analyzer, all the steps
> will execute. Thus if the query analyzer can have several steps, how would
> you setup the the several steps to execute?
> 2. I know that Visual Basic 6.0 and Visual Basic.NET 1.1 can have inline
> sql
> statements and/or stored procedures. Thus can DTS packages run Visual
> Basic
> 6.0
> and/or Visual basic.NET programs with stored procedures in them and/or
> inline sql statements? If so, would you show me how to do this with a DTS
> package? If not, can you tell me why this is not possibly with a DTS
> package?
> 3. i know that sql server is setup where certain jobs can be scheduled to
> run at various times. Can DTS packages be setup to run at scheduled times?
> If
> so, how would you accomplish this? can different DTS packages be setup to
> run
> in a certain order and can run only if the job before it runs
> successfully?
> If so, how would you do this with DTS packages?
> 4. In sql server 2005, DTS packages no longer will exist. What will be
> used
> in SQL server 2005 to replace the DTS packages?
>
> Thanks!


.

Relevant Pages

  • RE: Recover SQL files & DST packages from server backup
    ... Move Databases Between Computers That Are Running SQL Server ... In order to backup and restore the DTS Packages, it depends on how they are ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: Recover SQL files & DST packages from server backup
    ... > after you install the OEM copy on the SBS box. ... If the DTS Packages are saved to SQL Server, they would be saved in the ... > sysdtspackages table in the SQL Server msdb database. ...
    (microsoft.public.windows.server.sbs)
  • it all started on 5/27....
    ... individual DTS packages on SQL Server 2000 SP 4 that import and convert ... The SQL lives on a separate server than Pervasive. ... the same machine as SQL Server 2K SP 4. ... Now, if I execute the DTS packages individually on the server, all ...
    (microsoft.public.sqlserver.dts)
  • RE: DTS Designer problems after upgrade to SQL Server 2008
    ... SQL Server 2000 DTS Designer components are required to edit DTS packages. ... "SQL Server 2000 DTS Designer Components" ... No resolution was achieved. ...
    (microsoft.public.sqlserver.dts)
  • RE: DTS in SQL Server 2005
    ... To run SQL Server 2000 DTS packages in SQL Server 2005, ... that SQL Server 2005 Integration Services (SSIS) has been installed. ... you select Integration Services for installation, ...
    (microsoft.public.sqlserver.dts)
Loading