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

Figure 7-27 . Parameter mapping in the Execute Package task
Close the Execute Package Task Editor and disable the seq Test WriteFileFooter
Sequence container. Execute the package and observe the results. You should get res-
ults like those shown in Figure 7-28 .
Figure 7-28 . Success!
I like this pattern because it utilizes SSIS components without resorting to too
much scripting. I don't like everything about this pattern, though. I need to know the
number of rows before calling this package, which isn't hard to acquire—I can simply
add a Row Count transformation to a data flow and count the rows as they are loaded
into the extract file. But then I must reload the extract file, after the fact. For large files