0

I'm new about SSIS.

First of all,

  • Installed SqlServer-2017
  • Installed SSMS version 17
  • Installed SSDT standalone (this was hard)
  • Installed SSIS

After all installations done. There are two components for SSIS;

  • SSIS via login via SSMS (server type : Integration Services) : MSDB
  • Integration Services Catalog : SSISDB

What is this logic? I searched but couldn't find an exact answer to understand.

enter image description here

Chris Albert
  • 2,462
  • 8
  • 27
  • 31
rkapukaya
  • 77
  • 1
  • 8

1 Answers1

2
  • "SSIS via login via SSMS (server type : Integration services) " is legacy. Ignore it.
  • Storing packages in MSDB is also legacy and can be ignored

SSISDB (Integration catalog) has been the standard way of storing packages and running them since SQL 2012

If you are learning about SSIS, only read docs that explain SSISDB.

i.e. this https://learn.microsoft.com/en-us/sql/integration-services/create-the-ssis-catalog?view=sql-server-2014

Nick.Mc
  • 18,304
  • 6
  • 61
  • 91
  • Thanks Nick, as i understand; so i dont need to install SSIS from sqlserver installation center (add features.) Because since 2012, SSIS [ SSISDB (Integration catalog) ] comes with default. Am i right? – rkapukaya Apr 20 '20 at 13:17
  • You do need to install SSIS because you need the "runtime" - all the DLL and resource files required to actually run it. – Nick.Mc Apr 21 '20 at 12:39