Datasheet

it to Partner Extract. Double-click the destination to configure it. When the destination opens, click New
to create a new connection manager. When the Flat File Format dialog box opens, select Delimited and
click OK.
You’re now taken to the Flat File Connection Manager Editor (shown in Figure 1-9). Name the connection
manager Partner Extract and type C:\ExpertSSIS\partnerextract.txt for the file name (the directory, of
course, must already be created). Select the Column names in the first data row check box.
Figure 1-9: Flat File Connection Manager Editor
Next, go to the Columns page. In this page, make the column delimiter a vertical bar (|) by changing the
Column delimiter drop-down box as shown in Figure 1-10.
Click OK to exit the editor and return to the Flat File Destination Editor. Click the Mappings page
to confirm the data mappings and then click OK. Each time the data flow is run, the extract file is
overwritten.
14
Chapter 1: Getting Started
04_134115 ch01.qxp 4/24/07 6:40 PM Page 14