Using SSIS's graphical designer, the task is straightforward, if not entirely intuitive. Create an Integration Project with a Data Flow Task Create a new project.

Microsoft SQL Server Integration Services, or SSIS, allows you to extract data from databases, including. ... Locate the data reader task icon and drag it to the control flow window.

Context is important when selecting an option from the SSIS toolbox menu. The active window context must be changed by clicking anywhere on the Control Flow page when a DTSX file is open. Once you ...

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