Information générale
Forum:
Microsoft SQL Server
>Hi all,
>
>I need to update my SQL Server 2000 tables with rows from an Oracle table. Using a DTS package, how can I get only rows from the Oracle table that have a date value greater than the maximum date from the SQL Server table?
>
>Thanks
>
>Henok
Two ways that may work for you:
1) Get the Oracle table into a temporary table in the SQL database and run the query there. The drawback is that you have to bring in all records from the Oracle table.
2) Write a distributed query by using OPENROWSET(). It would accept a regular OLEDB connection string to connect to your Oracle database. Additional parameters accept the SQL statement to be run. This will only bring the required rows but it takes a little longer to process, depending on the number of rows on the table.
HTH
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement