Datasheet

Chapter 1: SSIS Solution Architecture
26
The source server will both provide the extracted data and handle the data flow transformation logic,
and the destination server will require any data load overhead (such as disk I/O for files, or database
inserts or index reorganization).
Following are some of the benefits of this approach:
There is decreased impact on the destination server, where potential users are querying.
Data flow buffers are loaded rapidly, given that the location of the source files and package
execution is local and involves no network I/O.
The impact on the destination server is limited, which is useful for destination servers that have
24/7 use, or the SSIS process runs often.
Following are some of the drawbacks of this approach:
The impact on the source server ’ s resources, which may affect applications and users on the
source server
Potential reduced performance of the data flow destination adapter and the inability to use the
SQL Destination adapter, which requires the package be executed on the same server as the
package
Destination Server Package Execution
Similar to the impact of running a package on a source server, running a package on the destination
server, as Figure 1 - 11 demonstrates, has similar benefits and drawbacks, just reversed.
❑
❑
❑
❑
❑
Figure 1-11
Source Data Path
Execution Impact
Load Impact
Execution Location
Destination files/data
Source files/data
Extraction Impact
c01.indd 26c01.indd 26 9/24/09 11:26:41 AM9/24/09 11:26:41 AM