Is anyone able to advise as to why this isn't mapping Col2(All_Active) in my generated package? It seems to be something related to the parenthesis in the column name (Sadly I can't just remove them!)
<OleDbDestination Name="Out" ConnectionName="Conn_MDR">
<Columns>
<Column SourceColumn="Col1" TargetColumn="Col1" />
<Column SourceColumn="Col2(All_Active)" TargetColumn="Col2(All_Active)" />
</Columns>
</OleDbDestination>
Any help much appreciated, I'm pulling my hair out now
