Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic Cube Partitioning

Status
Not open for further replies.
GrandMauler

GrandMauler

Programmer
May 16, 2007
74
US
I'm writting an IS package that stages the data in such a way that a new fact table is created per week of data.

However, I don't know how to tell the cube processing object in the package to dynamically create a new partition for the cube.

I'm guessing I need to write some DDL that inserts the new table name and runs it.

Anyone?
 
Status
Not open for further replies.

Similar threads

sugu.bala
  • Locked
  • Question
Dynamic Input column in Script task
Replies
0
Views
287
sugu.bala
sugu.bala
TomCarnahan
  • Locked
  • Question
Dynamic Dataflow destination
Replies
0
Views
66
TomCarnahan
TomCarnahan
flobird
  • Locked
  • Question
ssis dynamic file name and sheet name excel
Replies
1
Views
254
Motlatjo
Motlatjo
pndMaster
  • Locked
  • Question
Dynamic SQL - Where clause help
Replies
1
Views
136
Motlatjo
Motlatjo
Welshbird
  • Locked
  • Question
Using a dynamic flat file connection as the output from a VB Script Task
Replies
1
Views
94
Welshbird
Welshbird

Part and Inventory Search

Sponsor

Back
Top