MS SQL Server DTS - several steps in a dts package

Author

several steps in a dts package

Wendy Elizabeth

2005-09-26, 8:24 pm

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!

Tom Moreau

2005-09-27, 9:24 am

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@discu
ssions.microsoft.com> wrote in
message news:4A9BE740-61A5-4D60-9E4D- 82C2BB157D50@microso
ft.com...
>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!

Wendy Elizabeth

2005-09-27, 9:24 am

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@discu
ssions.microsoft.com> wrote in
> message news:4A9BE740-61A5-4D60-9E4D- 82C2BB157D50@microso
ft.com...
>
>
>

Tom Moreau

2005-09-27, 1:23 pm

Dunno if you can run .Net apps per se but you can run other .EXE's,
including those written in VB6.

Depends on what you mean by "inline SQL". Certainly, the Exec SQL task can
run any SQL you throw at it.

For references, www.sqldts.com is the gold standard.

--
Tom

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

"Wendy Elizabeth" < WendyElizabeth@discu
ssions.microsoft.com> wrote in
message news:34E104D4-618D-4E7D-A9A3- E306FE25DCAF@microso
ft.com...[color=darkred]
> 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:
>

Sponsored Links