hi Roel ,
thank you for ur reply , i have created a DTS Package and and filled it
with queries and stuff :) , it is working fine now , thanks again :)
Roel Schreurs wrote:[color=blue]
> Hi,
>
> Should could start trying the DTS Import wizard. You can start it[/color]
form[color=blue]
> the SQL Server Enterprise Manager. Select the Databases node in the
> console window. Choose All tasks | Import data from the context menu.[/color]
In[color=blue]
> one of the steps you can choose to write a query to select the data.[/color]
In[color=blue]
> another step, you can choose to save the wizards action into a new
> package. Later, you van view and modify the package. It is found in[/color]
Data[color=blue]
> Transformation Services node in the console window.
>
> Allthough there may be a far better way to get a max date value, you
> might consider storing the value in a settings table in the Oracle
> schema, so you can include in in you queries.
>
> Good luck,
>
> Roel Schreurs
>
>
fhadlaq@yahoo.com schreef:[color=green]
> > I need a little help here..
> >
> > I want to transfer ONLY new records AND update any modified records
> > from Oracle into SQL Server using DTS. How should I go about it?
> >
> > a) how do I use global variable to get max date.
> >
> > Where and what DTS task should I use to complete the job? Data[/color][/color]
Driven[color=blue][color=green]
> > Query? Transform data task? How ? can u give me samples. Perhaps[/color][/color]
you[color=blue][color=green]
> > can email me the Demo Package as well.
> >
> >
> > b) so far, what I did was,
> >
> > - I have datemodified field in my Oracle table so that I can[/color][/color]
compare[color=blue][color=green]
> > with datelastrun of my DTS package to get new records
> >
> > - records in Oracle having datemodified >Max(datelastrun), and[/color][/color]
transfer[color=blue][color=green]
> > to SQL Server table.
> >
> > Now, I am stuck as to where should I proceed - how can I transfer[/color][/color]
these[color=blue][color=green]
> > records?
> >
> > Hope u can give me some lights. Thank you in advance.
> >[/color][/color]
