Import external data

Hi friends,
I want to import data from remote database(oracle) to my sql
server
local database.
As one of the group mate suggested I used Import(Tasks -> Import)
Its ok. But I want this to be done for a frequent of times and put in
a schedule. How can I do this.
And every time I import, the duplicates will not be imported I mean
the old data will not be imported again. ONly the current data to be
imported.
How can I make schedule and not alowing to import old records again?
Thanks in advanceMake a linked server and a stored procedure that pulls the data using a NOT
EXISTS clause. Then create an agent job on sql server to run it on whatever
schedule you desire. The same can probably be accomplished using SSIS as
well.
<mrajanikrishna@.gmail.com> wrote in message
news:1190732099.352879.45570@.y42g2000hsy.googlegroups.com...
> Hi friends,
> I want to import data from remote database(oracle) to my sql
> server
> local database.
>
> As one of the group mate suggested I used Import(Tasks -> Import)
> Its ok. But I want this to be done for a frequent of times and put in
> a schedule. How can I do this.
>
> And every time I import, the duplicates will not be imported I mean
> the old data will not be imported again. ONly the current data to be
> imported.
>
> How can I make schedule and not alowing to import old records again?
>
> Thanks in advance
>