[SQL Server Data Warehousing] How to make sure that Reporting services can access data during ETL of database

How to make sure that Reporting services can access data during ETL of database

We have SQL Server 2008R2, SSRS and SharePoint 2010. We don't have OLAP cube for reportings.

We have need to Truncate all tables and import all data every night. We are doing this during night, but SSIS tasks takes about 2h.  We do lot of calculations in SSIS and we have milions of rows in tables.

What is simple way to make sure that Reporting Services can get data 24/7?

Analyses Services OLAP is not available for us.

Ken

---

Kenny_I

.

social.technet.microsoft.com/Forums