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?