SSIS package using dynamic configurations

240 pts.
Tags:
SQL Server Analysis Services
SSAS 2008
SSIS
SSIS Package 2008
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following