All,
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)
Thanks
Jason
The way I would do this is to put the truncates inside a single Sequence container and then have a single precedence constraint running from the container to the data flow.
Functionality should be the same, but it's tidier and groups things logically.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.