SQL Server Performance

xml to tables

Discussion in 'SQL Server 2005 General Developer Questions' started by arkiboys, Oct 10, 2008.

  1. arkiboys Member

    Hi,
    I am working on a few number of complex .xml files.
    The idea is to place these data into the sql server 2005 database tables.
    I have tried to use xml source task inside a ssis package but the error is:
    "Error at data flow task[xml source[1]]: The xml source Adapter does not support mixed content model on complex types."
    Does this mean the only way I can place the xml data into the sql server tables is to use openrowset ?
    Are there any other methods within sql server 2005?
    If I can somehow pass the xml contents of the .xml files as string or text, then I can go through them in sql and pull data out, etc...
    Any thoughts please?
  2. MohammedU New Member

  3. arkiboys Member

    Thanks BUT these links do not seem to answer my question.

Share This Page