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