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

Figure 7-17 . Parsing the row count and extract date
Now we have the footer row metadata in the data flow pipeline. We can terminate
this branch of the pipeline using another Derived Column transformation, der Trash
Destination Footer. Connect der Parse Footer to der Trash Destination Footer. Right-
click the data flow path and click Enable Data Viewer. Execute the package in the de-
bugger to view the contents of the footer row, as shown in Figure 7-18 .
Figure 7-18 . Footer row, parsed
You can see from Figure 7-18 that five (5) data rows exited the Conditional Split
transformation. We can observe the contents of the footer row after parsing in the Data
Viewer.
Consuming a Header Row
Header rows are even easier to read. Let's start with a look at the source file named
MyFileHeaderSource.csv :
5 rows, extracted 10/5/2011 10:22:12 AM
---------------
ID,Name,Value
11,Andy,12
22,Christy,13
33,Stevie Ray,14