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 |
|
mrajani
Starting Member
13 Posts |
 Posted - 2007-10-16 : 10:21:28
|
| Hi friends, I need to import data from oracle databse into local sql server.The data in the oracle tables are updating very often. So I need to do this import on a scheduled basis. I saved the DTS package in my file system. How can I run this package on a schedule.And one more thing, How can I import data from oracle based on a query to local tables?i.e select * from <oracle table> where updated_date >= [<date param>]so that I will import only the recent records instead of all records every time.Thanks in advance |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-10-16 : 10:30:42
|
| You can run the Package using DTSRUN command and add this command to a scheduled job to run the package at regular intervals. Read about creating jobs in SQL Server help.Regarding second question, do you have Updated_Date as a field in the oracle table?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
mrajani
Starting Member
13 Posts |
Posted - 2007-10-16 : 11:10:37
|
| Hi, Thank you for the reply. Yes, I have the updated_date column in the oracle table. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-19 : 22:15:51
|
| Or run it in windows scheduler. |
|
|
|
|
|
|
Import data using DTS