Database Reference
In-Depth Information
Figure 7-15 . Flat File connection manager Columns page for a file containing a footer row
You can see the footer row contents in the preview shown in Figure 7-15 . You may
or may not be able to view the footer row on the Columns page of the Flat File Con-
nection Manager Editor.
The next step is to separate the footer row from the data rows. To accomplish this,
you will use a Conditional Split transformation to isolate the footer row. There are a lot
of different ways to detect the footer row, but the trick is to pick something unique
about that row. In the SSIS Expression Language expression I define in Figure 7-16 , I
search for the term "rows" in the ID column. This condition will work as long as
there's never a chance that the term "rows" will legitimately show up in the ID
column of the data rows. Never is a very long time.
 
 
Search WWH ::




Custom Search