I have a simple Data Mapper file that is meant to extract Parent_Id from the source table and populate the Child_Id in the target.
Parent_Id is the Primary Key column. It is an is an Identity (AutoNumber) field. .
Child_Id is the Foreign Key column
The execution failed with the following Error message (I paraphrased it a little to de-identiy the actual names)
"The Connection point Connector from 'Transform, DB Writer 1, Database, Target_Table, Child_ID'
to 'Transform, DB Reader 1, Database, Source_Table, Parent_Id is an Identity (AutoNumber) column and can not be set directly."
On the mapper, the connector appears as a red line.
Based on the Error message, it appears that the Data Mapper behaves as if I am trying to connect the Child_Id to Parent_Id. This is obviously not the case as it is not possible to populate a Primary Key column that is constrained to be an auto-incrementing identity field.
There seems to be an issue with the Data Mapper's functionality here and it needs to be fixed.
Also, please review the word sequence in the error message.
How can I make this work for the short term?