I have to populate a table on SQLServer2000 from two tables on DB2 using a DTS package. I have setup the ODBC drivers for DB2.

To populate the table on SQLServer200 side i have to use cursors and transfrom data. I cant use the Data transformation task becuase i'm using cursors and loops and such. I have made a SQL script for this in a 'Execute Sql task' which is using the Other ODBC (DB2) connection.

How do I refer to the SQLserver2000 table in the Execute SQL task?

Thx for ne responses.