Database Reference
In-Depth Information
In this section, we will look at creating and consuming header and footer rows us-
ing SQL Server 2014 Integration Services.
Consuming a Footer Row
We begin by looking at how to consume a footer row. To start, create a file containing a
footer row. My file looks like this:
ID,Name,Value
11,Andy,12
22,Christy,13
33,Stevie Ray,14
44,Emma Grace,15
55,Riley Cooper,16
5 rows, extracted 10/5/2011 10:22:12 AM
To demonstrate, create your own file and name it
MyFileFooterSource.csv
. Create
a new SSIS package and rename it
ParseFileFooter.dtsx
. Add a Data Flow
task and switch to the Data Flow tab. Add a Flat File source adapter and double-click it
to open the Flat File Source Editor. On the Connection Manager page, click the New
button to create a new Flat File connection manager and open the editor. Name the Flat
File connection manager
My File Footer Source File
and set the
File Path
prop-
erty to the location of
MyFileFooterSource.csv
. Check the Column Names in
the First Data Row checkbox. Navigate to the Columns page to verify your configura-
tion matches, as shown here in
Figure 7-15
.
Search WWH ::
Custom Search