In order to configure and use SQL Server Data Transformation Services, the OLE DB Provider for DB2 must already be installed and data sources configured. A normal progression for installation and configuration would be the following:
The installation of Host Integration Server 2000 and SQL Server 2000 are tasks that we will skim over. Detailed installation information is found in the product documentation. We will focus more on configuration issues since these are more challenging.