IMPORT DATA FROM XML SOURCE TO SQL

Hello,

I'm trying to import data from a xml file (several tables inside) into sql tables.

- In the xml source, I choose the xml and xsd files and I see all tables perfectly.

- Drag the xml source output to Sql Destination input, choose one table to import and create the sql table

- I execute the task and it concludes ok

- In Execution Results window appears as warnings as fields of each one other tables (giving information about this fields are not used at the process and it'll be better removed it in order to increase performance), no errors and success task. The problem is that no one data is imported into sql destination (wrote 0 rows).

Process window:

Information: 0x4004300A at OPP, DTS.Pipeline: Validation phase is beginning.

Warning: 0x80047076 at OPP, DTS.Pipeline: The output column "field_1" (66374) on output "TABLA1" (50424) and component "XML Source" (27281) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

Information: 0x40043006 at OPP, DTS.Pipeline: Prepare for Execute phase is beginning.

Information: 0x40043007 at OPP, DTS.Pipeline: Pre-Execute phase is beginning.

Information: 0x4004300C at OPP, DTS.Pipeline: Execute phase is beginning.

Information: 0x40043008 at OPP, DTS.Pipeline: Post Execute phase is beginning.

Information: 0x40043009 at OPP, DTS.Pipeline: Cleanup phase is beginning.

Information: 0x4004300B at OPP, DTS.Pipeline: "component "SQL Server Destination" (20427)" wrote 0 rows.

SSIS package "package.dtsx" finished: Success.

The program '[408] package.dtsx: DTS' has exited with code 0 (0x0).

If I import data of xml file from access, I haven't any problem. All tables are imported

I don't know what can be. Thanks a lot.

Gema

Use a data viewer to see if there's any data in the pipeline.

-Jamie

|||

there's no data into data viewer... What I do?

Gema

|||

It sounds as though its more likely that there is no data coming out of your source file rather than them failing to get inserted into SQL.

I have no idea as to why that may be though. For starters, work on the assumption that there is a fault in the way you have configured it.

-Jamie

|||

I think too that's a problem of xml source configuration (not about sql destination) but I don't know if can be a problem with xml-xsd files (is doesn't at my hand) or because some property of data flow task and/or its elements must be changed...

Thanks a lot, Jamie

Gema