Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
majnoon
Starting Member
26 Posts |
 Posted - 2002-12-11 : 11:33:15
|
| I have an Oracle server which I access via a DTS package. The package populates a corresponding table in SQL server after truncating it. To make the pckage run faster I want to have the DTS package run a script that queries the Oracle table and only brings back the records that are missing in the SQL server table by joining it to the Oracle table. However, when I try and run a script with a join the package tells me that the Oracle table or view does not exist. Is there a way around this?????If the above is not possible can I pass a parameter to the package. The Oracle table has a row id which is unique and sequential. Passing the parameter would mean that I can run a query such as SELECT * FROM ORACLE_TABLE WHERE ROWID > 1000. Is this possible, and if so how can you do it????Wishing you a peaceful journey |
|
|
|
|
|
DTS