469,106 Members | 2,338 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 developers. It's quick & easy.

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!
Jul 20 '05 #1
2 2987

"Andreas Terzis" <gr******@pacbell.net> wrote in message
news:40*********************@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
Jul 20 '05 #2
"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!
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

15 posts views Thread by Chakkaradeep | last post: by
7 posts views Thread by tshad | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.