select only new records (ODBC stage)
Posted: Mon Apr 11, 2005 5:31 am
Hi all!
I must select from sources only new records. In my source I have timestamps (MSSQL server binary8 timestamps). I'm using job parameter telling me what is the last number of previously loaded record and in transformer I'm rejecting old ones.
I'm wondering - is there some way to use this jobparmeter in ODBC stage to select there only new records??
Or is there another way to take from source only new records when we hav e timestamping in database and information (i.e. from file) what was the last row number previously loaded??
I must select from sources only new records. In my source I have timestamps (MSSQL server binary8 timestamps). I'm using job parameter telling me what is the last number of previously loaded record and in transformer I'm rejecting old ones.
I'm wondering - is there some way to use this jobparmeter in ODBC stage to select there only new records??
Or is there another way to take from source only new records when we hav e timestamping in database and information (i.e. from file) what was the last row number previously loaded??