Flat File Source Patterns - SQL Server Integration Services Design Patterns - page 194

Figure 7-11 . Configuring the Script component inputs
Click the OK button to close the Conditional Split Transformation Editor. It is im-
portant to note that this would have required a Script component in earlier versions of
SSIS because the Flat File connection manager in previous versions couldn't parse files
containing rows with a varying number of columns.
Terminating the Streams
You can use several data flow components to terminate a data flow path. In a produc-
tion environment, this would likely be an OLE DB destination adapter. In a develop-
ment or test environment, you may want to terminate with a component that doesn't re-
quire database connectivity or database object creation.