Related
TopicsThe Data Transfer Tool moves data from DB2 databases to SQL Server 2008 databases by programmatically building an SSIS package for each of the database tables to be transferred and then executing the package. An SSIS package is a collection of tasks to be executed in an orderly fashion in the SQL Server SSIS engine.
The programmatically built package contains a single Data Flow task, under that there is a Data Source component, a Data Destination component, and optionally a Data Transform component as well as an Error Row Log component. It is saved in the“local/shared” folder or specified by the pkdir command line parameter, and named after the table name as [table name]_RunTimePackage.dtsx. It can be reused by the Execute Package Utility of SQL Server Integration Services. It can also be loaded into the SQL Server Business Intelligence Development Studio for debugging purpose.