Database Reference
In-Depth Information
Figure 7-16
.
Configuring the Conditional Split transformation
To terminate the data rows pipeline—which flows from the Conditional Split trans-
formation's default output—I use a Derived Column transformation.
The footer row output requires more parsing. We send it to another Derived
Column transformation named der Parse Footer.
Note
Jamie Thomson wrote a great post entitled “SSIS: Suggested Best Practices
and Naming Conventions” (
http://sqlblog.com/blogs/jamie_thomson/
ventions.aspx
)
. I often use Jamie's naming conventions.
We want the number of rows and the datetime of the extraction. I use the expres-
sions in
Figure 7-17
to parse the footer row count and footer extract datetime:
Search WWH ::
Custom Search