Integration Services or Analysis Services

ninefoureight

ninefoureight

ninefoureight

Associate
Joined
21 Oct 2002
Posts
1,045
OK i have two courses lined up for SQL Server 2008 R2..

SSIS & SSAS

Already using SSRS, both will take me a week. My day job is generally data extract and reporting. Which would be more appropriate to do first?

I will do the other but at a later date. Any tips or suggestions from those that have been there and done it?
 
Do you just extract data from the database(s) and manipulate it, or do you extract data from source and populate database(s) with it (or do you do both, if so think about the proportion of workload)?

SSIS is about automation and industrialisation, so if you spend lots of tine doing repetitive loading etc, that is the course to do first. If the loading from source is largely already done, then analysis will probably serve you better.
 
You must log in or register to reply here.
Back
Top Bottom