FLAT FILE DESTINATION

            After source and transformation mappings we need to specify the destination to store the result set.

Destination mapping:

• In data flow, after source mapings, drag and drop the “Flat File Destination” into designer surface.

• Select the “Source”, Click on “Source green arrow” and connect to the “Destination” (After source green arow selection click on the “Destination”).

• “Destination” red symble will go if we map target file.
• Right click on the “Destination” and select “Edit” Option.

• “Flat File Destination Editor” window will open.

• In the above screen shot “Flat File Connection Manager” taken existing source connection. We should create new connection for target.
• Click on the “New” button then “Flat File Format” window will open.

• Choose the required format and click “OK” button. “Flat File Connection Manager Editor” window will open.

• We need to give connection manager name (if we don’t give, it will take defoult name).
• Click on browse button and choose the target location then give the name for the target file.

• Click on “Columns” option and check the columns.

• Click “OK” button then ”Flat File Connection Manager Editor” will disapper.
• In “Flat File Destination Editor” window select the “Mappings” option and check the source to target mappings.

• Click “OK” button to complete the destination mappings.

• We can change target file path by editing the connection manager “Destination”.