Re: several steps in a dts package
- From: "Tom Moreau" <tom@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 27 Sep 2005 14:13:01 -0400
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:34E104D4-618D-4E7D-A9A3-E306FE25DCAF@xxxxxxxxxxxxxxxx
> 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!
>>
>>
>>
.
- References:
- Re: several steps in a dts package
- From: Tom Moreau
- Re: several steps in a dts package
- From: Wendy Elizabeth
- Re: several steps in a dts package
- Prev by Date: import from excel, rounded numbers
- Next by Date: windows logged on username
- Previous by thread: Re: several steps in a dts package
- Next by thread: Problem: DynamicPropertiesTaskAssignments Collection in JScript
- Index(es):
Relevant Pages
|
