March 3, 2009 at 4:25 am
Bit of a complicated one!
Every day we get a csv file which contains data.
We need to edit the file and save it as an xml file
Problem
Each row in the CSV file needs to be in a set format:
(Data highlighted in bold)
FirmFSARef 30
TransRef 221
FirmCode 130
BuySell S
TypeOfInstrument A
UnitPrice 3.10
PriceNotationb GBP
Currently we have been using a Mail Merge to do this, and then copy and paste the data into a text file and then save it as an XML file.
Required
- SSIS file to collect the file from a local folder
- MailMerge the data (as above)
I can do the upload manually.
Can this be done, can any one suggest a better way of doing this
March 3, 2009 at 7:13 pm
So is your question: "Can I use SSIS to convert a CSV file to XML format?"
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
March 4, 2009 at 2:01 am
Yes I suppose it is....
And how would i do it...
March 4, 2009 at 5:15 am
OK, as you've probably discovered, there is no XML dataflow destination in SSIS, so your task is not simple.
But you're not the first to want to do this. Check http://blogs.conchango.com/jamiethomson/archive/2006/07/11/4209.aspx for some ideas on how to get data outputted in XML format using SSIS.
Phil
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply