One Data Conversion, Many Destinations

#1

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.

#2

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

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

Quote:

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.
.

#3

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

"Todd C" wrote:

Quote:

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

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

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.
.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

One Data Conversion, Many Destinations

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

One Data Conversion, Many Destinations - 01-07-2010 , 02:55 PM

RE: One Data Conversion, Many Destinations - 01-08-2010 , 07:57 AM

RE: One Data Conversion, Many Destinations - 01-11-2010 , 07:49 AM