One Data Conversion, Many Destinations

[i***@yahoo.com]

Is there a way, in SSIS 2005, to have one data conversion
transformation connect to multiple SQL Server destination objects? It
isn't working for me.

[Todd C]

All the standard 'Transforms' in SSIS 2005 (and 2008) have only one pipeline
output except one, the Multi-Cast. It basicaly makes as many copies of the
pipeline as you need so you can send them to different destinations.

HTH
--
Todd C
MCTS SQL Server 2005

Post by i***@yahoo.com
Is there a way, in SSIS 2005, to have one data conversion
transformation connect to multiple SQL Server destination objects? It
isn't working for me.
.

[Todd C]

Addendum: Forgot about the Conditional Split transform, which breaks the
original data flow into sub-sets of data, but does NOT make copies of any
data.

The original answer stands: use a Multi-Cast.
--
Todd C
MCTS SQL Server 2005

Post by Todd C
All the standard 'Transforms' in SSIS 2005 (and 2008) have only one pipeline
output except one, the Multi-Cast. It basicaly makes as many copies of the
pipeline as you need so you can send them to different destinations.
HTH
--
Todd C
MCTS SQL Server 2005

Post by i***@yahoo.com
Is there a way, in SSIS 2005, to have one data conversion
transformation connect to multiple SQL Server destination objects? It
isn't working for me.
.