I would like to DTS those records in a particular Oracle table into a SQL table that were created after a certain date time value, which will be extracted from a table in the SQL database

The DTS script looks something lik

SELECT
INTO analyst.Log_Event
FROM "ORA"."Log_Events

What I want to do is add a where clause, something like

WHERE "ORA"."Log_Events".EventTime > (SELECT Max(EventTime) FROM analyst.Log_Events

but I cannot seem to figure out the correct syntax. Any help would be greatly appreciated!

I can see a couple of possible ways

1. Linked server from SQL Server to Oracle. You can then use the Oracle
instance rather like it was local.
2. If using SQL Server 2000 you could
a) Grab the Date value from SQL Server and read into a Global Variable
in an ExecuteSQL task
b) In the Source for the DataPump from Oracle to SQL Server use the
Global Variable (?)

so something like

SELECT <col list> FROM "ORA"."Log_Events"

WHERE EventTime > ?

You should then be able to map your Global Variable to the ? placeholder.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Dale Fye" <anonymous (AT) discussions (DOT) microsoft.com> wrote

extracted from a table in the SQL database.