Importing XML using SSIS


I have an XML file and an XSD defined for it. I am importing this XML file into SQL Server 2005.

The SSIS package runs fine but there is no data in the table. I'm creating the table on the fly through SSIS itself.

When I click on preview of OLEDB Task, it shows no data but the correct columns. I checked my mappings and everything else.

I search online and found some reference to namespaces, is there some sort of special namespace I need to put on the XSD or XML to import into SQL Server?

Please let me know.

Thank you, Slick

more ▼

asked Mar 24, 2010 at 12:31 PM in Default

avatar image

1.3k 75 104 147

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Hi You do not need any special namespace in the xml or the xsd for importing data using ssis.Pls make sure the xsd defines the right schema of the xml.Try to open the xml in a browser and see if you can view the data normally. Thanks, Kannan

more ▼

answered Oct 22, 2010 at 09:04 AM

avatar image

2.8k 56 65 71

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 24, 2010 at 12:31 PM

Seen: 2425 times

Last Updated: Mar 24, 2010 at 12:31 PM

Copyright 2016 Redgate Software. Privacy Policy