March 3, 2009 at 6:46 am
Bit of a complicated one!
Every day we get a csv file which contains data.
We need to open the file stored in a local folder and turn it into a 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)
Can this be done, can any one suggest a better way of doing this
March 3, 2009 at 8:56 am
I do it all in SSIS.
Here's a link for how to do it using a Script Component in SSIS:
http://agilebi.com/cs/blogs/jwelch/archive/2007/06/01/xml-destination-script-component.aspx
And here's a place where you can purchase a Custom XML Destination Component:
http://www.keelio.com/Products/ProductsOverview/XMLSSISToolkit/tabid/160/Default.aspx
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply