Results 1 to 3 of 3

Thread: DTS Package Incremental update

  1. #1
    Join Date
    Oct 2005
    Posts
    5

    Unhappy 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

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,922
    You can use a Query as source for you data transfer task, the query should only select the delta.

  3. #3
    Join Date
    Oct 2005
    Posts
    5

    Red face

    Thank you skhanal,

    I appreciate it.

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


    Thanks,
    Paris

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •