x

Importing XML using SSIS

Hello,

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

Slick84 gravatar image

Slick84
1.3k 75 102 142

(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

aRookieBIdev gravatar image

aRookieBIdev
2.3k 47 55 61

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x927
x146
x66
x29

asked: Mar 24, 2010 at 12:31 PM

Seen: 2127 times

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