Wednesday, February 15, 2012

Evenly splitting output in SSIS

I would like to split the data stream so that 1 copy can be sent to a lookup task, and the other can be sent as input to another target.

There doesn't seem to be a way to do this in SSIS; but maybe I should be considering other options?

Can anyone suggest a way to copy data to two different sources?I think you want to use the multicast component.|||Boy, I had experimented with that before and completely forgot about it. Thanks!

No comments:

Post a Comment