Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    4

    Unanswered: How to add new partition automatically using DTS task ?

    Dear You:

    My fact table increased about 3 million perday, I want to save the fact table by date, for example table named "20031203" means the fact of 2003/12/3.

    I know this should use 'partion' in Analysis Service, but I don't exactly how to do this job using DTS?

    Could anyone help me on this ?

    Thank you!!!

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: How to add new partition automatically using DTS task ?

    Do you mean you want to save the data in a table called 20031203 which is created by DTS everyday for a new datetime stamp?

  3. #3
    Join Date
    Oct 2003
    Posts
    4

    Re: How to add new partition automatically using DTS task ?

    thank you first!

    I mean I want to make DTS add PARTITION automatically to my cube, the new PARTITION contains the new fact table of the new day.
    Now I can do this manually in Analysis Service, but I want make it automatically.

    by the way your understanding below is another question I should ask.

    Originally posted by joejcheng
    Do you mean you want to save the data in a table called 20031203 which is created by DTS everyday for a new datetime stamp?

Posting Permissions

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