I have a DTS package (Sql version 8) that calls a sub-package (Executes on
main thread) and the main package successfully executes. However when I
look at the destination tables of the sub-package, not all of the expected
data is there. It seems like it only runs one of the 3 transforms that I
have between the same 2 connections. When I run the sub-package standalone,
then the data is as expected. Anyone else experience this behavior?

Thanks,
Al

In message <eUXjOOHhEHA.3632 (AT) TK2MSFTNGP09 (DOT) phx.gbl>, Al Cadalzo
<cadalzo (AT) hotmail (DOT) com> writes
I don't know why this should happen, but try turning on the logging,
both file and SQL server options for the child package and see if this
can shed any light on the matter.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org