Bandwidth Monitor
SQLDTS.comSQLIS.comSQLIS Wiki
File Inserter Transformation
By Allan Mitchell
Version 2005
Level Intermediate
Page 1 | Page 2 | Page 3 | Page 4 | Page 5 | Page 6 | Page 7

The Data Flow Task

Add a DataFlow task to the designer and join it with an On Success constraint from the ForEachLoop container (The green bit hanging from the bottom of the container)

Double Click on the Data Flow task and you will notice your tabs at the top change from Workflow to Data Flow.

Again, let us show you what the Data Flow section will resemble once we have everything in place to help with visualizing things as we move forward.

DataFlowComplete

A difference to note between the Workflow and DataFlow sections is that whereby the green arrows in Workflow depict constraints, in the DataFlow they show movement of data.

Page 1 | Page 2 | Page 3 | Page 4 | Page 5 | Page 6 | Page 7
Related Articles & Links
Read File Transformation