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">
<Column SourceColumn="Col1" TargetColumn="Col1" />
<Column SourceColumn="Col2(All_Active)" TargetColumn="Col2(All_Active)" />

Any help much appreciated, I'm pulling my hair out now