I'm trying to take an XML document and dump the contents into a table. 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 ...

When you start working with SQL Server and SSIS, it won't be long before you find yourself wishing you could change bits of SQL queries dynamically.

There is one last step to use the query you built. Open your source in the Date Flow, set the Data Access Mode to SQL Command From Variable, and then select your query variable in the dropdown.