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