Not as XML using the SQL Server 2005 XML datatype, but as the parsed data values into a table with a column for each element.<BR><BR>The simple method would appear to be using SQL Server's SSIS ...

Execute SQL tasks run stored procedures or SQL queries from SSIS packages. A task executes any SQL statements that have been passed to it in sequential order. It provides you with a handy way to ...

I have to import this XML file into database using an SSIS project that was given to me. (I did not sign up to do SSIS, and only deal with it once a month, but there's nobody else to do it ...

Here's a quick trick to keep things running. By Eric Johnson 04/12/2010 When building an SSIS package, you probably find that a lot of the time you don't want one bad row to blow up the whole ETL.