dbTalk Databases Forums  

How to question for one package calling another

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


Discuss How to question for one package calling another in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
George Morton
 
Posts: n/a

Default How to question for one package calling another - 02-07-2005 , 10:54 AM






I have two packages. Call the first SuperA (it has steps to execute other
packages only) and the second SubB (which has Scripts, Datapumps, and Data
Driven Queries). SuperA executes SubB; SubB has code which controls the
execution of datapumps depending on txt files being present or missing. SubB
runs fine when executed by itself. But when executed using SuperA, steps
within SubB fail with messages like: "SubStep 'StepName' failed with the
following errors". There are no errors listed, because a script in SubB set
ExecutionStatus to Complete (when a file is missing or has length zero).

So, my question is "How do I get SubB to execute properly when invoked by
SuperA?"



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.