DTS - Execute Package Task

It is available on sqlserver 7

with dtsrun from DOS

I dont believe the execute package task is available in SQL Server 7.

i couldn't verify, but if it is available in SQL Server 7, then only from SP3 on, which has some options related to SQL 2000...

Listening & Learning

If you type from DOS : dtsrun, you will be able to specify the package that you want to run connecting to the server.
   If it doesn't work find it in ..\mssql7\binn

I dont think this is what vd is asking.  Please clarify vd -
1) do you want to know how to execute a dts in sql server 7 from the command prompt?

2) to know if you can execute processes normally done at the command prompt as part of a dts in sql server 7?

- sy

SYASSIN, in SQL 2000 you can execute a single step from a DTS package, even if the package contains several steps.

The question is really if this is a functionality that is available in SQL 7 SPx or not...

CHeers

Of course...I use it on SQLServer 7...With Enterprise Manager you can create a package with several steps and task, save and execute it immediate, or scchedule it.

Thanks for the comments!
Clarification: The Execute Package Task is available from the Toolbox in DTS
on 2000. It allows one to execute an already created package from the current
package.  It is not available in SQL 7 sp1.
I was hoping someone knew if this task is available in one of the SQL 7 SP's
(or have an alternate suggestion), so that I don't have to install SQL 2000
on the server just yet!

If you want to run a dts package on 7 you can create a vb script task and do the following

Set dts_package = CreateObject("DTS.package")
dts_package.LoadFromSQLServer "SERVER", "USER", "PASSWORD", , , , , "PACKAGE"    

dts_package.execute()
   

The vb script task sounds great.
I don't see a vb script task though...do you mean the Active Script task, or
something else?

Yep that is it.

I tried the vb script. It didn't work ( a syntax error).
Could you explain/expand  the example somewhat?

Thanks, this is an excellent work around!

Angeliii   : Thanks, indeed SP3 does not have the Execute Package object available.