Drag the Data Flow Task onto the Control Flow Surface. Double-click the "Data Flow Task" object to open up its design surface.

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

You can design your SSIS packages in various ways, but you should always keep your goals and other factors in mind The other night, I gave a presentation on SSIS architecture to a local user group ...