I am very new in SSIS. I have the Report Server set up with two dozen of the OLAP reports in it. The reports are connected to the OLAP database on a seperate computer running on Sql 2005 server and the data source for the OLAP DB is pointed to the warehouse database on another computer running on Sql 2000 server. The warehouse server updates daily from a number of "Production" Sql servers running on Sql 6.5 and Sql 7.0 with the legacy front-end data entry application. I know the update from the "Production" Sql 6.5/7.0 servers to the warehouse server complete around 9am in the morning everyday. How do I set up a package in SSIS to schedule the update of the OLAP database say 9:30am so that end-user can have the latest data to their report. The OLAP database has one fact table, half a dozen of cubes and ten dimensions. I know it is not an easy task to set up the package in SSIS. Please provide sample and step on how to do this. Thanks. One last question how to prevent/warn users from opening the report when SSIS updating the OLAP database?
Wow! that is 'whole project' question.
I recommend you to read about the REAL project, which offers a end-to-end BI implementation using SQL Server 2005 (including SSIS)
http://www.microsoft.com/technet/prodtechnol/sql/2005/projreal.mspx#EZGAC
http://www.microsoft.com/sql/solutions/bi/projectreal.mspx
There are a few webcast to watch as well; just search on this forum to get the links to it.
No comments:
Post a Comment