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.
input validation sql-server-2005 ssis
user2000769
source share