I'm an SSIS newbie, putting together an SSIS package to push data from a source server to several destination servers. The destination table that is going to be populated is going to be truncated (the data is for reporting purposes,) with no need to save anything. I've done a QA test (which is a 1-to-1 push,) I know I can use a multi-cast in my dataflow, but it's one thing in the control flow I want to confirm.
At the moment, until I check with the customer, I want to work on the presumption that if any of the truncate tasks fail, the package should cease, rather than trying to load the data. If I'm reading the information in the Precedence Constraint editor screen correctly, by having ALL the incoming precedence constraints set to be Logical ANDs, it should work as desired.
(I've got 5 Execute SQL Tasks all feeding into the Data Flow Task)