Change SQLCommand in 2005 Package? -
08-24-2006
, 11:41 AM
I am writing a package in SQL Server 2005 SSIS that downloads data from
Oracle (using a DataReader) and loads it into SQL Server 2005. I only want
to perform incremental updates, so I created a table in SQL Server that
stores the last run date of the job. After I retreive this date I want to
use it in my WHERE clause in the Oracle DataReader. The DataReader doesn't
have a input so I'm not sure how to do this. Does anyone know how? Thanks |