dts only selected rows

I have to dts rows by timestamp. For example if my dts downloaded at 10 am then in the next run i want to grab rows updated in the AS400 after 10am. what is the best way to go in ssis?

thanks...

kushpaw

You'll have to store the timestamp somewhere - perhaps in a file or a table, and then use a dynamic SQL statement using that timestamp.

-Jamie

|||

Perhaps, consider to use some sort of execution/audit tables and have your packages to get data extraction timeframesfrom there each time .

Rafael Salas

|||

There is a timestamp field in both sql and as400 tables. I can select the last timestamp from the destination table and query source for that timestamp. Is that what u mean?

-kushpaw

|||

kushpaw wrote:

There is a timestamp field in both sql and as400 tables. I can select the last timestamp from the destination table and query source for that timestamp. Is that what u mean?

-kushpaw

Yeah something like that. That would work.

|||thanks for your suggestion Rafael. this would be an ssis way, just what i was looking for.