The Package Contains Two Objects With The Duplicate Name Of Xxxx And Xxxx

Hi all,

I am creating a Data Flow custom component in SSIS, and my input/output columns are dynamically created depending on the value of a custom property of the component.

Then, as soon as I modify this custom property, I make some job in SetComponentProperty(), that I have overrided in my PipelineComponent, to create my input and ouput columns.

After validation, I have the following error message:

Error 3 Validation error. Data Flow Task: DTS.Pipeline: The package contains two objects with the duplicate name of "output column "AMOUNT" (4714)" and "input column "AMOUNT" (4711)". Package.dtsx 0 0

I create an input column named "AMOUNT" with an ID 4711 and an output column named "AMOUNT" with an ID of 4712.

What is surprising is that when I manualy create the same columns with the default advanced editor of my component, using the menu "Show Advanced Editor...", there is no error !!!

I think that I am doing something wrong but I don't know what...!

Have someone any idea about that?

Here is the code I use to create new input columns:

IDTSInputColumn90 newInputColumn = inputColumns.InputColumnCollection.New();

newInputColumn.Name = virtulaInputColumn.Name;

newInputColumn.LineageID = virtulaInputColumn.LineageID;

newInputColumn.UsageType = DTSUsageType.UT_READONLY;

newInputColumn.ErrorRowDisposition = DTSRowDisposition.RD_NotUsed;

The virtulaInputColumn is the linked real input column that I get from IDTSInput90.GetVirtualInput()



Here is the code I use to create new output columns:

IDTSOutputColumn90 newOutputColumn = defaultOutput.OutputColumnCollection.New();

newOutputColumn.Name = outputColumn.Alias;

newOutputColumn.SetDataTypeProperties(DataType.DT_WSTR, 0, 0, 0, 0);

The outputColumn is here one of my objects that I have created from the custom property of my custom component.

Thanks in advance for any help...

David