DTS Package Incremental update

Hi Everybody,

Right now i have a DTS package thats populating a fact table,I'm trying to do an incrmental update of the fact table (which has a sequential#id).

any ideas ,please

Thanks,
Paris

You can use a Query as source for you data transfer task, the query should only select the delta.

Thank you skhanal,

I appreciate it.

I'm new to MS OLAP cud you please gimme a few more details.


Thanks,
Paris