Post reply

Parsing XML from one DB into columns of another

  • June 20, 2016 at 11:06 am

    #308546

    I have a database that receives XML formatted data (stored as text in a Postgres db) that I need to import into my SQL Server 2012 db and break into the appropriate columns. How would I best handle this? Save each source row to an individual XML file and then use an XML source to parse it? Can I do it all in memory within SSIS? Any examples would be welcome, too.

  • June 20, 2016 at 11:11 am

    #1885894

    You could use the XML source for this, but you would not need to save each row to it's own file. Dump all rows into one XML file and SSIS can read and process them all at once. Much more efficient than doing it one file at a time. And yes, SSIS does this in memory on the SSIS server.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply