SSIS 2005, how to resolve the error "input column has a line identifier that was not previously used in the data flow task" programmatically

I am trying to write a program that automatically adds columns from OLE DB Sources to all components in a .dtsx file (the target is SSIS 2005). When I process .dtsx with my program, it seems that the columns are added correctly, but when I open the modified package, this message appears in the components:

the input column has a line identifier that was not previously used in the data flow task.

If I double-click on a component and then click OK, the error will disappear.

My question is:

Is there a way for programmatic behavior to be the same? I will try to automate this operation for the user using this program, but with this error, block me in the project.

+7
input validation sql-server-2005 ssis
source share
1 answer

Both the source and target columns must have the same row identifier.

0
source share

All Articles