Hi,
I'm playing with the XML import capabilities of SSIS, but I can't get it to
work at all. I'm trying a very simple XML file, and in the DataFlow, I
only have the XML Connector object and the database connection object.

I'm importing directly from an output stream of the XML object into a
database table. I don't receive an error at all, but I don't get any
records in the table.

Whats the secret?

Thanks
Bill

Hello Bill,


So when you plug in the XML file to the XML Source Adapter in the dataflow
you are asked to generate or provide an XSD or use an inline schema. If
this proves successful then you should see n outputs from the souce adapter.
Is this what you are seeing? if it is then maybe the output that is hooked
up has no data??

Without seeing the file I cannot say.

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Bill,

Importing XML into SQL Server 2005 works fine for me.

It would help to have more information.

If you right click on the OLE DB Destination and select Edit, does
what you see in the Mappings pane make sense re mapping the XML to the
desired columns?

It might be worth adding a Data Viewer between the XML Task and the
OLE DB Destination in the Data Flow tab.

When you run the package do both components on the Data Flow Tab turn
green?

If you look on the Execution Results tab is there any indication of
problems?

Andrew Watt [MVP]

On Sat, 1 Apr 2006 22:54:12 -0800, "Bill Swartz"
<swartz.bill (AT) gmail (DOT) com> wrote: