I am trying to do a DTS, with the Enterprise Manager from Sql Server 2000, to get informations from a table located in a Oracle database to fill a table located in a SQL database. I've done the connection with the Oracle database and I created a Execute SQL task with the select that I want to get the infromations from the table in the oracle database, wich is just a Id and Description. Also I've done the connection with the SQL database. Now I would like to know what steps I have to do to fill the table in the SQL database.
Start Free Trial
