In order to see how differently SQL Server Integration Services
accomplishes the same task, it will be helpful to see how it was done with DTS.
Some of the DTS concepts are the same in SSIS. Using a connection to SQL 2000
Server, an ODBC connection to Oracle 10G XE server and a Transform Data Task are
all needed to accomplish the task in DTS. Using these components, the copying
process can be designed into a DTS Package as shown in Figure 2. Although Transform Data Task has a limited repertoire,
it does copy tables admirably well. It even has a "Copy
Table" Transform Data Task which is not seen in
the Visual Studio 2005 IDE. Thus, this flashback may not be comparing apples
with apples, but it at least shows that the underlying concepts are not
radically different.
Figure 2
