Showing posts with label How to make sure that Reporting services can access data during ETL of database. Show all posts
Showing posts with label How to make sure that Reporting services can access data during ETL of database. Show all posts

Tuesday, June 4, 2013

[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

Saturday, June 1, 2013

[SQL Server Data Warehousing] 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

Search This Blog