Home Forums SQL Server 2005 SQL Server 2005 Integration Services Import XML Data into SQL Server database using SSIS package????? RE: Import XML Data into SQL Server database using SSIS package?????

  • April 1, 2008 at 10:10 pm

    #796996

    I am also trying to import a xml file to SQL tables using SSIS Data Flow Task --> XML source

    --> OLEDB destination. I provided the xml file and a xsd file in the XML souce editor.

    The extraction of the XML file will created 5 tables. My problem is that one of the tables

    is empty. Any idea how to solve this problem? I have tried to add a "root" node to the

    XML file, and it worked. Is there any other way to solve this problem without manually

    changing the XML file?

    Thanks!