To transfer data

From the HCOSS Transfer Data tool, click the Transfer Data Tasks tab.

Do one of the following:

To define a new transfer data task:
1. Click New.
2. In the Name field, type a name for the transfer data task file.
3. Click OK.
To edit an existing transfer data task, select an existing task from the Available Tasks drop-down list.

Choose one of the following to apply to the Available Tasks drop-down list:

Local	To save the transfer data task file to the directory specified by the Local HCOSS Directory HCOSS option.
Shared	To save the transfer data task file to the directory specified by the Shared HCOSS Directory HCOSS option.

Choose one of the following to apply to the Associated DDL Task drop-down list:

Local	To show local DDL tasks on the Associated DDL Task drop-down list.
Shared	To show shared DDL tasks on the Associated DDL Task drop-down list.

From the Associated DDL Task drop-down list, select a DDL task file created using the Generate DDL tool.

From the Source Connection drop-down list, select a DB2 connection previously defined using the Manage Connections tool.

From the Destination Connection drop-down list, select a SQL Server connection previously defined using the Manage Connections tool.

To customize your transfer data task, click Customize. See To customize a transfer data task for more information. Optional.

Click Save to save the transfer data task.

To export the transfer data task as one or more SSIS packages, click Export as SSIS Packages. Optional.

Click Transfer.

Warning: While the transfer is running, do not to switch to another HCOSS tool. This action could produce an undesirable result. If you must switch to another tool, click Cancel and wait for the transfer process to stop before switching.

On the Results tab, verify that the data transfer has completed properly.