I have denormalized source data that I want to use SSIS to normalize
and distribute to the propert destination tables. What is the proper
SSIS task that can do this? I don't think the Conditional Split would
work. Would the Multicast Transformation do the trick?

That's a very vague question. The best answer I can give is that yes, SSIS
will be able to do this. I don't know exactly what components you need though
because I don't have enough knowledge about the scenario. What I can be
pretty sure of is that there will be more than one way of achieving this and
those mthods may or may not include the MULTICAST or CONDITIONAL SPLIT.

You understand your requirement better than anyone so you are better placed
to answer your question. If you ask a more specific question then I'd be glad
to try and help out.

Note that MULTICAST and CONDITIONAL SPLIT are components, not tasks.

-Jamie


"imani_technology_spam (AT) yahoo (DOT) com" wrote:

Hello imani_technology_spam (AT) yahoo (DOT) com,

The MULTICAST transform will simply replicate streams of your data with no
overhead. This may or may not work. Denormalised in what way? It could
be that a Script Component as a transform is what you want do maybe you have
something like this

http://www.sqlis.com/default.aspx?307

The thing is denormalised could mean a million things.

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com