Hi I have to create a package which process the analysis services cube and its partitions,and dimensions. This package should run every 15 minutes to process the cube. I have a procedure which creates the database in analysis services db and relational db for the current month. I have another procedure which creates daily tables in relational db and daily cubes in analysis services. I have to process the cube using the current day date using current day relational db table. (The relational db tables are populated by a different process which is fine.) EX: Current day : 09-11-08, i have to process the cube using the data in table 09-11-08 days data. For tomorrow : 10-11-08, i have to process the cube using the data in table 10-11-08 days data. and so on.... If the month changes, it has to take that particular day and process the cube. The package should process only the past 7 days data from the current date and the current dates data. How can i do this using ssis package.? (Dont want to implement Proactive caching) How can i check the connection string for each day in the package and how it can be managed in the connection string.? How can i manage the Analysis Services Processing Task (Checking the partitions and measures) How can I manage the connection string dynamically if the month changes Any ideas are helpful. Sql version: 2008

Software/Hardware used: