Configuring the Data Flow To configure the Data Flow task for better performance, you can configure the task's properties, adjust buffer size, and configure the package for parallel execution.

The following example shows how to create an SSIS Data Flow Task that extracts data from a Sybase database table and loads it into a [!INCLUDE ssNoVersion] database table.

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

Hi there,<BR><BR>Yeah, XML data flow task tries to read the whole file into memory first, no workaround for that I'm afraid.<BR><BR>I guess you could get your hands on some piece of XML parsing ...

Do you want to backup your current database before you run a purge package? You are in luck; SSIS contains a handful of database maintenance tasks for these and other special occasions.