newbieQ: I'm building a package to removes activities.
Activities are chained via a parent actvity id
Would the best approach be to create a series of packages to delete each hierarchical level or 1 package + a series of deletes with pre-ops?
I have the same problem with an Parent ID and I use an Message Queue Target where I write a custom XML message with the Parent ID. This message is picket up by a second dts and in the dts parameters I post the Parent ID to a prompted variable .
This prompet variable you can use a custom source query.
With that way you can get a new source with the result from an old dts.
When you need more information, just leave me a messages.