Re: several steps in a dts package

Tom Moreau:

Can you tell me if DTS packages an run exec's that contain DLL to run
VB.NET and/or VB 6.0 programs?
Is there a URL and/or a group of URL(s) yuo can refer me to? I would like
to use these URL(s) for reference?
One additional question, can I run inline SQL from a DTS package?

Thank you very much for your assistance!

" wrote:

> 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: ActiveX script works in DTS but not in job, why?
    ... Account that SQL Agent runs under and it is a Local Admin on the box. ... As another test I saved the script as a .vbs file and tried running it, ... Microsoft OLE DB Provider for SQL Server ... that would be since I need to be able to load DTS packages from either a SQL ...
    (microsoft.public.sqlserver.dts)
  • Re: sql2000 to 2008 upgrade
    ... is there a way to uninstall it in SQL 2000 so I don't ... but don't see any meta data packages to edit and save in msdb. ... This server has zero DTS packages. ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.setup)
  • Re: memory management with multiple instances of SQL Server
    ... you can still run 2000 DTS packages in SQL2005. ... As I stated before you can set a max memory setting ... for SQL Server so that it does not use more than what you set for the memory ... But DTS and SSIS packages run outside SQL Servers memory space so you ...
    (microsoft.public.sqlserver.setup)
  • Re: ActiveX script works in DTS but not in job, why?
    ... Peter DeBetta, MVP - SQL Server ... As another test I saved the script as a .vbs file and tried running it, ... Microsoft OLE DB Provider for SQL Server ... 2000 databases including DTS packages. ...
    (microsoft.public.sqlserver.dts)
  • Re: several steps in a dts package
    ... Depends on what you mean by "inline SQL". ... Columnist, SQL Server Professional ... DTS packages can run ActiveX VBScript tasks. ...
    (microsoft.public.sqlserver.dts)