Saturday, February 25, 2012

add extra path to new component fails

I have a derived column component which has an regular output and an error output.

This works fine.

I want to add an extra regular output path.

I create a new OLEDB destination component and name it X

I right click on the derived column component and select "add path"

I then select X as the recipient of the new path.

And it errors with this garbage below

How can all the inputs be used up, it is a new component! It doesn't have any inputs!

Anyone know why this is happening (apart from the fact that it is not possible for me to go more than about 4 hours without encoutering another cryptic SSIS error that has no corresponding help topic on the MS website)

error message: (once again the MS help topic returns nothing)

===================================

All the available inputs on the target component are connected to outputs. Edit this component to define new inputs before proceeding. (Microsoft Visual Studio)


For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.762&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=DtsComponentNoOutputsFree&LinkId=20476


Program Location:

at Microsoft.DataTransformationServices.Design.PipelineTaskDesigner.AddNewPath(PipelineComponentMetadata sourceDtsComponentObject, PipelineComponentMetadata destinationDtsComponentObject)
at Microsoft.DataTransformationServices.Design.DataFlowDiagram.OnAddPath(MenuCommand sender, CommandHandlingArgs args)
at Microsoft.DataWarehouse.Design.CommandHandlingInfoMap.HandleCommand(MenuCommand menuCommand)
at Microsoft.DataWarehouse.Design.ComponentDiagram.InvokeCommand(MenuCommand menuCommand)
at Microsoft.DataTransformationServices.Design.DataFlowDiagram.InvokeCommand(MenuCommand menuCommand)
at Microsoft.DataWarehouse.Design.ComponentDiagram.Microsoft.DataWarehouse.Interfaces.ICommandTarget.InvokeCommand(MenuCommand menuCommand)

Most transformations have only one output. If you would like for the same output information to go to more than one component you should use the multicast transform after the derived column and have that pass on the output to as many places as you would like.|||

how stupid that it is shown as a menu option, and that it even goes through the process of allowing you to select another component

|||

Adolf,

'Add Path' option is just the equivalent of joining DF components via red/green arrows; it is not for creating additional outputs in a component.

If you need an additional data stream, you would need to use the multicast transformation or perhaps an scritp component.

No comments:

Post a Comment