question

Slick84 avatar image
Slick84 asked

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

ssisxmlimport-dataetl
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
aRookieBIdev avatar image
aRookieBIdev answered
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
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.