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

Producing a Footer Row

Let's look at producing a footer row and adding it to the data file. For this pattern, we
will leverage project and package parameters. We will also leverage the Parent-Child
pattern, which is discussed in detail in Chapter 16 . We are not going to build the pack-
age that creates a flat file containing data. We will start with the assumptions that an
extract file exists and we know the number of rows and the extract date. We will use
parameters to transmit metadata from the parent package to the child package. Let's get
started!
Create a new SSIS package and name it WriteFileFooter.dtsx . Click on the
Parameters tab and add the following package parameters:

Name Data

Type Value Required

AmountSum Decimal 0

DateFormat
String True

Debug Boolean True

False
Delimiter String ,

True
ExtractFilePath String

LastUpdateDateTime DateTime 1/1/

1900 True

RecordCount Int32

0 True

The parameters, when entered, appear as shown in Figure 7-20 .