dbTalk Databases Forums  

Executing a DTS from another DTS...

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Executing a DTS from another DTS... in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Andreas Terzis
 
Posts: n/a

Default Executing a DTS from another DTS... - 04-03-2004 , 06:02 AM






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

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Executing a DTS from another DTS... - 04-04-2004 , 10:00 AM






What does "Doesn't work" mean?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Andreas Terzis" <gr8patra (AT) pacbell (DOT) net> wrote

Quote:
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



Reply With Quote
  #3  
Old   
Andreas Terzis
 
Posts: n/a

Default Re: Executing a DTS from another DTS... - 04-04-2004 , 06:00 PM



Allan,
Thanks for the reply. "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 will try to get the exact code but as of the
last few days I am out of the office, so I hope I am making a little bit
of sense.
Thanks again,
Andreas


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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.