SSIS and SSRS are both part of SQL Server however they have very different uses and functions.
The short answer to the question “What is the main difference between the two?” is SSIS is primarily for moving and transforming data, SSRS is for reporting.
For those that prefer the longer explanation here is more detail listing the main use cases, and functionality of SSIS and SSRS.
What is SSIS?
In older versions of SQL Server (Prior to 2005) the predecessor to SSIS as we know it today, was called DTS.
SSIS is used for:
- Data pumping
- ETL Processes
What is SSRS?
MS describes it well – “Reporting Services is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources.”
SSRS first appeared on the scene as an afterthought to SQL 2000.
SSRS is used for:
- Report Designing
- Report Building
- Report Managing
How to get SSIS and SSRS
Both these products come packaged with SQL Server, so to get your hands on them, you need to head over to the Microsoft site and get busy downloading the SQL Server Evaluation versions
Best resource, course or website to learn more about SSIS and SSRS
The SQL Server Central stairway to SSIS series is a great starting point for those wanting to learn more about the ins and outs of SSIS.
For those of you interested in learning more about SSRS here is great list of resources to get you started.