Results 1 to 3 of 3

Thread: DTS Package Incremental update

  1. 10-14-2005, 09:19 AM #1
    Paris
    Paris is offline Registered User
    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
    Reply With Quote Reply With Quote
  2. 10-14-2005, 10:32 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can use a Query as source for you data transfer task, the query should only select the delta.
    Reply With Quote Reply With Quote
  3. 10-14-2005, 01:56 PM #3
    Paris
    Paris is offline Registered User
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules