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/
archive/2012/01/29/suggested-best-practises-and-naming-con-
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