Load a XML into Database using SSIS 2012

Question

I have a XML-File which is stored on a server. It can be reached over a URL. I need to Load the XML-Data into my Database, using SSIS 2012/Visual Studio 2010.

I've done this before in SSIS 2008 and it worked like a charm. Now I moved to 2012 and I am getting the following Error: "[XML-Source [46]] Error: The file "http://www.xxxx.xml" was not found. Please verify the file path and try again."

Anyone knows?

That URL looks bad. Do you mean a local network server like http://servername/xxxx.xml, or an internet address like http://www.somewhere.com/xxxx.xml. (You should also explain that "XML-Quelle" just means "XML-Source", for anyone who doesn't know how to read that.) — criticalfix
– criticalfix, Commented Jun 5, 2013 at 15:22

DBAndrew · Accepted Answer · 2014-09-19 19:43:39Z

1

Here is the fix for VS 2010 and VS 2012.

FIX: SSIS 2012 XML Source task cannot load data from a URI http://support.microsoft.com/kb/2991526

Enjoy! :)

answered Sep 19, 2014 at 19:43

DBAndrew

6,9782 gold badges22 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

New to stackoverflow · Accepted Answer · 2013-06-05 15:59:56Z

0

Make sure you close the xml file before loading. you have to generate an XSD file make sure the schema defination is correct in the XSD file.

answered Jun 5, 2013 at 15:59

New to stackoverflow

15 bronze badges

1 Comment

Jendrik Over a year ago

Schema is correct, since it worked before. I can't close it, because it isn't stored on my pc.

Collectives™ on Stack Overflow

Load a XML into Database using SSIS 2012

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related