471,893 Members | 1,773 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,893 software developers and data experts.

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 3017

"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 YellowAndGreen | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.