Execute DTS Package within another DTS Package

Execute DTS Package within another DTS Package

Post by Darren Gree » Fri, 04 Oct 2002 22:51:55



Execute a package from a package
http://www.sqldts.com/default.aspx?6,104,215,0,1

--
Darren Green (SQL Server MVP)
http://www.sqldts.com

Check out the PASS Community Summit - Seattle, the largest and only user
event entirely dedicated to SQL Server, November 19-22.
http://www.sqlpass.org/events/seattle/index.cfm


Quote:> Can I have a task within a package that runs another DTS
> package.

> I am using SQL 7.0

> TIA
> Ally.

 
 
 

Execute DTS Package within another DTS Package

Post by Allan Mitchel » Sat, 05 Oct 2002 05:09:51


You most certainly can.  In SQL Server they 2000 MS have given us
a new ExecutePackage task to make things easier but you could still
do it from 7 as well.

Execute a package from a package
http://www.sqldts.com/default.aspx?6,104,215,0,1
--

Allan Mitchell
MCSE, MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community for SQL Server
professionals - http://www.sqlpass.org