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 ...

Data Flow tasks are one of the most powerful and versatile components of SQL Server Integration Services (SSIS), a platform for building and managing data integration and transformation solutions ...

Let's look at an example. Fig. 1 shows a simple data flow that loads data from a flat file, called NewStores.txt, to a table in SQL Server called Stores_Staging. Fig. 2.