Executing a DTS from another DTS...

Hi there,
I am trying to execute a DTS package from another DTS
package and change some variables in the original DTS. I
have used the info on the following page but it doesn't
work: http://www.sqldts.com/default.aspx?215. Would you
have any input?
Thanks,
Andreas

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!"Andreas Terzis" <gr8patra@.pacbell.net> wrote in message
news:40709788$0$202$75868355@.news.frii.net...
> Hi there,
> I am trying to execute a DTS package from another DTS
> package and change some variables in the original DTS. I
> have used the info on the following page but it doesn't
> work: http://www.sqldts.com/default.aspx?215. Would you
> have any input?
> Thanks,
> Andreas
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

You'll need to give more information - exactly what does "doesn't work"
mean? Did you get any error messages? Which version of SQL Server are you
using? Have you tried using the Execute Package task?

You might also want to post to microsoft.public.sqlserver.dts.

Simon|||"Doesn't work" means that I get no errors when I execute the child DTS
but nothing happens; in other words the child
package doesn't get executed. My child package is not saved with an
owner or other password. I am using SQL Server 2000. I will try the
Execute DTS task, but I wanted to try the ActiveX method first because
in the future I want to pass variables from the child to the parent
package. Do you know anything about the Yukon version of DTS? Is it
going to have enhancements over the 2000 version?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!