Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 When should we use ETL process?

Author  Topic 

farhad.k
Starting Member

7 Posts

Posted - 2011-03-28 : 05:16:43
Hi,

When should we use ETL process? While it is possible for SSAS to connect to multiple data sources, what is the necessity of using ETL process?

What is the relationship between SSAS and SSIS? Which of them should be considered firstly? Is it possible to implement a BI project without ETL?

Thanks
   

- Advertisement -