Skip to Content
Former Member
Jul 24, 2013 at 10:10 AM

Extracting or loading bulk text data from XML source / Target


Hi All,

Could you please share your ideas on how to extract bulk text data from XML source file (attached document) and load it to a XML target or target DB table.

XML source file contains mainly two fields Author description and Book description which holds large amount of text data of data type Varchar(1024).

I created a simple job 'xml_job' using the below

Source file: Attached xml source file

Transformation : XML_Pipeline

Target: Xml file / Target table

the job (xml_job) is failing.

Please suggest on how to load the data to target and make the job successful.

Quick response appreciated.