Hi.
Im trying to via Data Integration, to export some data from DW to a csv file using the CSV provider as destination.
I want the columns to be named differently as the column names in DW
instad of : ProductId, ProductName. I want MyId, MyName.
In the Setting of the job, I manually handle the mappings of the fields. And add the required Columns the to destination table, and ajust the mapping
The resulting CSV is not using the naming of the mapping, but returns the column names of the source
If i look at the xml with the setting for the job, the columns are writen as wanted in there.
If I try to use the XML provider as destination, and change to my requered column names, then the mapping is working as expected and i get a result like this.
<table tableName="EcomProducts">
<item table="EcomProducts">
<column columnName="MyName"><![CDATA[Prod 1]]></column>
<column columnName="MyId"><![CDATA[PROD1]]></column>
</item>
</table>
Is this behaivor of the CSV provider a bug or a feature ?
Regards
Kenneth
