I am copying data from one source to destination SQL CE table using the data flow task. I have two extra requirements which I am not sure how to achieve.
1.) One source column needs to be mapped to two destination columns. In the column mapping dropdown the column name disappears after mapping it to one destination column.
2) some custom values for columns need to be added, which are not present in source. For e.g. a default value for some destination columns which is not present.
Any pointers would be extremely appreciated. Thanks,
[Please mark the post as answer if it answers your question]
View Complete Post