spen_lang
asked on
SSIS CSV to XML
Hi,
I was wondering if the following is possible in SSIS and if someone could point me in the right direction...
Basically I would like to convert CSV files provided by customers into an XML file, how the position of the required columns in CSV may vary depending on customer.
For example we will require the following columns to be appended to the XML:
>> Account Code
>> Collection Date
>> Delivery Date
>> Product Code
>> Quantity
Customer A may send a file that has the following columns in order:
>> Collection Date
>> Delivery Date
>> Product Code
>> Quantity
>> Description
>> Type
>> Account
Customer B may send a file that has the following columns in order:
>> Product Code
>> Collection Date
>> Delivery Date
>> Account
>> Quantity
>> Description1
>> Description2
Is it possible to setup a mapping for each customer. For example a SQL table that looks like:
So the number in the table would show where the column is positioned in the customers text file.
I hope this makes sense...
Thanks, Greg
I was wondering if the following is possible in SSIS and if someone could point me in the right direction...
Basically I would like to convert CSV files provided by customers into an XML file, how the position of the required columns in CSV may vary depending on customer.
For example we will require the following columns to be appended to the XML:
>> Account Code
>> Collection Date
>> Delivery Date
>> Product Code
>> Quantity
Customer A may send a file that has the following columns in order:
>> Collection Date
>> Delivery Date
>> Product Code
>> Quantity
>> Description
>> Type
>> Account
Customer B may send a file that has the following columns in order:
>> Product Code
>> Collection Date
>> Delivery Date
>> Account
>> Quantity
>> Description1
>> Description2
Is it possible to setup a mapping for each customer. For example a SQL table that looks like:
So the number in the table would show where the column is positioned in the customers text file.
I hope this makes sense...
Thanks, Greg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.