Hi, I have been assigned a task to read data from a Oracle table and XML file. There is a ID column which joins both the dataset. The output should be written to a XML file. I have planned to do this using SSIS. I dont have a SQL database assigned for this project hence can't load the XML data to SQL table. Is there anyway to connect the 2 datasets and generate XML file on the fly. I'm just a starter in SSIS and have never used XML in SSIS so far. Could you please guide me through on how to do this? Any help is greatly appreciated. Thanks.
Hello, You can use an XML source and and Oledb source to connect to the xml file and oracle respectively.use the appropriate transformations like joins,xml transformation etc.The resulting dataset can be written to a XML only using a script component. The script component requires some c# coding to write the data in to a xml file. In ssis you do not have a XML destination task directly. Hope this was useful. Thanks, Kannan
Thanks for the quick response Kannan. My XML file looks like this, 1234 My Office
www.myoffice.com addr1 addr2 Here 12354 012345 0
firstname.lastname@example.org 11000 ABC moreInfo
XYZ 5 now AT NONE XYZ NONE Hence it results in multiple output which I'm not able to join and connect with Oracle. Any thoughts?
Hi, I managed to create the SSIS. When I ran the same, the data from XML file is not being read and inserted as
NULL.It doesn't throw up any error too. Am I missing something? Could you please help me resolving this?