SSIS:System Requirements: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
Line 38: Line 38:


===Officially Supported by Melissa===
===Officially Supported by Melissa===
*Microsoft SQL Server 2022 – Microsoft Visual Studio 22
*Microsoft SQL Server 2022 – Microsoft Visual Studio 2022
**SSDT – SQL Server Data Tools – 17.2.40118.0
**SSDT – SQL Server Data Tools – 17.2.40118.0
***Accessible via Visual Studio Installer
***Accessible via Visual Studio Installer

Latest revision as of 16:59, 17 May 2024

← SSIS:Data Quality Components

SSIS Navigation
Introduction
System Requirements
Quick Start
SSIS Installation
Subscribe



The Data Quality Components for SSIS are 32/64 bit tools available for Windows XP/2003/2008/Vista/7/8/10 and Microsoft SQL Server 2005/2008/R2 (Deprecated) - 2012 & 2014 (Supported).

  • There is a known issue with Windows 10 with SQL2012 + VS2010, if you have data viewer enabled it will hang the process. This issue happens regardless if our components are used or not, so it is likely a Windows issue. However, we are currently still investigating this issue.

Minimum Requirements

  • 64-Bit Windows 7 or newer
  • Microsoft SQL Server 2012 or newer
  • 6 GB hard-disk space for Web Service update
  • 30 GB hard-disk space for On Premise data
  • 4 GB RAM

Recommended Requirements

  • 64-Bit Windows 10 or newer
  • Microsoft SQL Server 2016 or newer
  • 8 GB hard-disk space for Web Service update
  • 40 GB hard-disk space for On Premise data
  • 8 GB RAM


What Versions of SQL Server/Visual Studio Is Your Components Supported in?

Melissa Data currently supports SQL Server versions 2014, 2016, 2017, 2019 and 2022. We also provide components for SQL Server 2005, 2008, 2010, and 2012 as part of the SSIS Installation, however, they are no longer supported.

Certain Microsoft SQL Server version are officially supported by specific Microsoft Visual Studio versions for our components. BusinessCoder and future new component will only be offered in SSIS 2010 and newer.

SSIS Installation

Melissa's SSIS components must be installed to the same drive as the SQL Server Integration Services instance.

You can verify the location of SQL Server Integration Services by using the Windows Search Bar and entering "Services.msc". In the Services menu, scroll down until you see "SQL Server Integration Services XX.X". Then right click on the entry and select Properties. In the General tab, locate the Path to executable directory. For example: "C:\Program Files\Microsoft SQL Server\110\DTS\Binn\MsDtsSrvr.exe"

In this case, SQL Server Integration Services is installed to the C: drive, so a regular installation is needed.

If the path to executable shows other than a C: drive, you will need to install Melissa's SSIS components using the SSIS Install Other than C: drive instructions.

SSIS Install Other than C: drive Instructions: FAQ:SSIS:Install Other Than C: Drive

Officially Supported by Melissa