SSIS vs SSRS: What is the difference?

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?

SSIS package under development

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-warehousing
  • Data pumping
  • ETL Processes

What is SSRS?

A SSRS report being created in Business Intelligence Studio

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.

Rob StGeorge
Senior SQL Server Database Administrator residing in Auckland, NZ

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.