Hi there

i want to implement a dynamic delta-upload
Source is Oracle, Target SQL2000; I want to extract data from Oracle only for a couples of days - perhaps the last 3 days and not a full upload of the whole table. The starting date and the ending date of this range are stored in a table in the SQL-Server.

I wrote a select to get the data from Oracle like "SELECT * FROM 'table' WHERE DATE1 BETWEEN ? AND ?". Then I declared two global variables and mapped theses variables to the parameters

Now I want to set the global variables from another select which is using the connection to the SQL-Server. So, how? Or is there any other way? (I guess... ;-)
Thanks for any hint
regard
Robert

You can do the assignments to the vairables in an ExecuteSQL task.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
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


"rholling" <robert.holling (AT) b-i-con (DOT) de> wrote

whole table. The starting date and the ending date of this range are stored
in a table in the SQL-Server.
mapped theses variables to the parameters.
guess... ;-))