Parenthesis in Column Name

 

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 

0

Comments

0 comments

Please sign in to leave a comment.