Help on using DTS global variables to select rows from Oracle table!

[wondemh]

Hi folks,

I am trying to do an incremental update on my tables in SQL Server. I am trying to do this by pulling rows from an Oracle table that have an activity date that is more recent than most recent date in the SQL Server table. I am doing this using a DTS Package. In the package I have an Execute SQL task that pulls the latest date from my SQL Server table and puts it in a global variable. Then I use the global variable in a Transform Data taks and say:

select * from Oracle_table where activity_date > ?

But DTS doesn't seem to be able to access the global variable when it is used to transfer data from Oracle to SQL Server. I would greatly appreciate any help!!!

Thanks

Henok

 

[tlbroadbent]

Check Darren Green's SQLDTS web site. He has a page about using Global Variables in T-SQL.

http://www.sqldts.com/article.asp?nav=1,6,205,7

Terry Broadbent

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin