Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
SSIS Cube building
2 views
Skip to first unread message
Tim
Nov 9, 2009, 3:20:05 PM11/9/09
to
Sql server 2008, AS question:
Have a cube with 5 partitions
Using SSIS to build & deploy cube
Each partition represents a day of data.
Each day the 'oldest' partition's select query is editted to pick up the
latest day (ie. instead of deleting a partition & adding a new one, I change
the date in the select statement of the oldest partition to simply look at a
new day)
If I process/deploy manually from BIDS, all 5 correct days are selected,
built & deployed.
If I change the date, build the cube & then run the SSIS job ( with FULL
deploy option ) the cube is rebuilt as if the select statement was not
amended, so the same old 5 days of data is built into the cube ... so the 5th
partition remains with the same data although it's associated 'select query'
has changed.
The Processing settings for the AS task are process FULL for everything ...
what am I missing ?
Have a cube with 5 partitions
Using SSIS to build & deploy cube
Each partition represents a day of data.
Each day the 'oldest' partition's select query is editted to pick up the
latest day (ie. instead of deleting a partition & adding a new one, I change
the date in the select statement of the oldest partition to simply look at a
new day)
If I process/deploy manually from BIDS, all 5 correct days are selected,
built & deployed.
If I change the date, build the cube & then run the SSIS job ( with FULL
deploy option ) the cube is rebuilt as if the select statement was not
amended, so the same old 5 days of data is built into the cube ... so the 5th
partition remains with the same data although it's associated 'select query'
has changed.
The Processing settings for the AS task are process FULL for everything ...
what am I missing ?
--
tryingToLearn&Earn
0 new messages