SSIS:System Requirements - Revision history

Admin at 16:59, 17 May 2024

2024-05-17T16:59:21Z

← Older revision		Revision as of 16:59, 17 May 2024
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

Admin at 23:31, 14 May 2024

2024-05-14T23:31:36Z

← Older revision		Revision as of 23:31, 14 May 2024
Line 22:		Line 22:

	==What Versions of SQL Server/Visual Studio Is Your Components Supported in?==		==What Versions of SQL Server/Visual Studio Is Your Components Supported in?==
	Melissa Data currently supports SQL Server versions ~~2012,~~ 2014, 2016, 2017, 2019 and 2022. We also provide components for SQL Server 2005, 2008 and ~~2010~~ as part of the SSIS Installation, however, they are no longer supported.		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.		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.

Admin at 17:09, 10 November 2023

2023-11-10T17:09:26Z

← Older revision		Revision as of 17:09, 10 November 2023
Line 3:		Line 3:
	{{CustomTOC}}		{{CustomTOC}}

	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 (~~Depreciated~~) - 2012 & 2014 (Supported).		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.		*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.

Admin at 21:19, 8 May 2023

2023-05-08T21:19:06Z

← Older revision		Revision as of 21:19, 8 May 2023
Line 22:		Line 22:

	==What Versions of SQL Server/Visual Studio Is Your Components Supported in?==		==What Versions of SQL Server/Visual Studio Is Your Components Supported in?==
	Melissa Data currently supports SQL Server versions 2012, 2014, 2016, 2017, and ~~2019~~. We also provide components for SQL Server 2005, 2008 and 2010 as part of the SSIS Installation, however, they are no longer supported.		Melissa Data currently supports SQL Server versions 2012, 2014, 2016, 2017, 2019 and 2022. We also provide components for SQL Server 2005, 2008 and 2010 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.		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.
Line 38:		Line 38:

	===Officially Supported by Melissa===		===Officially Supported by Melissa===
			*Microsoft SQL Server 2022 – Microsoft Visual Studio 22
			**SSDT – SQL Server Data Tools – 17.2.40118.0
			***Accessible via Visual Studio Installer
			***Select edition of Visual Studio you want to add SSDT, select Modify
			***Select SQL Server Data Tools under Data storage and processing
			**SSIS – SQL Server Integration Services Projects 2022 – 16.0.5131.0
			***https://marketplace.visualstudio.com/items?itemName=SSIS.MicrosoftDataToolsIntegrationServices
			**SQL Server 22 Developer – Integration Services 64bit (CMD Prompt – DTExec.exe) – 16.2211.5693.3
			***To execute projects via CMD prompt, SSIS 2022 requires 64bit SQL Server Integration Services from SQL Server 22 Developer Edition
			***SQL Server 22 Developer Edition Download: https://www.microsoft.com/en-us/sql-server/sql-server-downloads
			***In SQL Server 2022 Setup Feature Selection, select Integration Services
			**Visual Studio 22 – Download: https://visualstudio.microsoft.com/downloads/
	*Microsoft SQL Server 2019 - Microsoft Visual Studio 2019		*Microsoft SQL Server 2019 - Microsoft Visual Studio 2019
	**SQL Server Data Tools for Visual Studio 2019 – Select SQL Server Data Tools from the Data Storage and Processing section – https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15		**SQL Server Data Tools for Visual Studio 2019 – Select SQL Server Data Tools from the Data Storage and Processing section – https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15

Admin at 00:21, 18 October 2022

2022-10-18T00:21:13Z

← Older revision		Revision as of 00:21, 18 October 2022
Line 47:		Line 47:
	**SQL Server Data Tools for Visual Studio 2015 (14.0.61021.0) - https://msdn.microsoft.com/en-us/mt186501.aspx?f=255&MSPPError=-2147217396		**SQL Server Data Tools for Visual Studio 2015 (14.0.61021.0) - https://msdn.microsoft.com/en-us/mt186501.aspx?f=255&MSPPError=-2147217396
	*Microsoft SQL Server 2014 - Microsoft Visual Studio 2013		*Microsoft SQL Server 2014 - Microsoft Visual Studio 2013
	*Microsoft SQL Server 2012 - Microsoft Visual Studio 2010/2012		*Microsoft SQL Server 2012 - Microsoft Visual Studio 2010/2012 - '''Date of Deprecation: 7/24/2023'''
	*Microsoft SQL Server 2010 - Microsoft Visual Studio 2008 - '''Deprecated'''		*Microsoft SQL Server 2010 - Microsoft Visual Studio 2008 - '''Deprecated'''
	*Microsoft SQL Server 2008 - Microsoft Visual Studio 2005 - '''Deprecated'''		*Microsoft SQL Server 2008 - Microsoft Visual Studio 2005 - '''Deprecated'''

Admin at 23:52, 10 August 2022

2022-08-10T23:52:44Z

← Older revision		Revision as of 23:52, 10 August 2022
Line 37:		Line 37:
	SSIS Install Other than C: drive Instructions: [[FAQ:SSIS:Install Other Than C: Drive]]		SSIS Install Other than C: drive Instructions: [[FAQ:SSIS:Install Other Than C: Drive]]

	===Officially Supported by Melissa ~~Data~~===		===Officially Supported by Melissa===
	*Microsoft SQL Server 2019 - Microsoft Visual Studio 2019		*Microsoft SQL Server 2019 - Microsoft Visual Studio 2019
	**SQL Server Data Tools for Visual Studio 2019 – Select SQL Server Data Tools from the Data Storage and Processing section – https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15		**SQL Server Data Tools for Visual Studio 2019 – Select SQL Server Data Tools from the Data Storage and Processing section – https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15

Admin at 23:51, 10 August 2022

2022-08-10T23:51:26Z

← Older revision		Revision as of 23:51, 10 August 2022
Line 26:		Line 26:
	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.		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 "<code>Services.msc</code>". 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: "<code>C:\Program Files\Microsoft SQL Server\110\DTS\Binn\MsDtsSrvr.exe</code>"

			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 Data===		===Officially Supported by Melissa Data===

Admin at 00:11, 30 March 2022

2022-03-30T00:11:53Z

← Older revision		Revision as of 00:11, 30 March 2022
Line 8:		Line 8:
	===Minimum Requirements===		===Minimum Requirements===
	*64-Bit Windows 7 or newer		*64-Bit Windows 7 or newer
	*Microsoft SQL Server ~~2008~~ or newer		*Microsoft SQL Server 2012 or newer
	*6 GB hard-disk space		*6 GB hard-disk space for Web Service update
			*30 GB hard-disk space for On Premise data
	*4 GB RAM		*4 GB RAM

	===Recommended Requirements===		===Recommended Requirements===
	*64-Bit Windows 10 or newer		*64-Bit Windows 10 or newer
	*Microsoft SQL Server ~~2012~~ or newer		*Microsoft SQL Server 2016 or newer
	*12 GB hard-disk space		*8 GB hard-disk space for Web Service update
			*40 GB hard-disk space for On Premise data
	*8 GB RAM		*8 GB RAM

Admin at 22:18, 20 August 2020

2020-08-20T22:18:21Z

← Older revision		Revision as of 22:18, 20 August 2020
Line 20:		Line 20:

	==What Versions of SQL Server/Visual Studio Is Your Components Supported in?==		==What Versions of SQL Server/Visual Studio Is Your Components Supported in?==
			Melissa Data currently supports SQL Server versions 2012, 2014, 2016, 2017, and 2019. We also provide components for SQL Server 2005, 2008 and 2010 as part of the SSIS Installation, however, they are no longer supported.
	Melissa Data currently supports SQL Server versions 2012, 2014, 2016 and ~~2017~~. We also provide components for SQL Server 2005, 2008 and 2010 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.		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.


	~~===Regarding SQL Server 2019 Compatibility===~~
	~~We recommend SSIS 2016/2017 for the most stable environment for our components.~~

	~~We are working on updating our Data Quality Components to work natively on SSIS 2019.~~

	~~Please check back on this page for future news on SSIS 2019 compatibility.~~


	===Officially Supported by Melissa Data===		===Officially Supported by Melissa Data===
			*Microsoft SQL Server 2019 - Microsoft Visual Studio 2019
			**SQL Server Data Tools for Visual Studio 2019 – Select SQL Server Data Tools from the Data Storage and Processing section – https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15
			**SQL Server Integration Services Projects – https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects
			***Can also be installed from Visual Studio 2019 Tools > Extension and Updates Section.
	*Microsoft SQL Server 2017 - Microsoft Visual Studio 2017		*Microsoft SQL Server 2017 - Microsoft Visual Studio 2017
	**SQL Server Data Tools for Visual Studio 2017 - https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017#ssdt-for-vs-2017-standalone-installer		**SQL Server Data Tools for Visual Studio 2017 - https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017#ssdt-for-vs-2017-standalone-installer

Admin at 21:10, 11 February 2020

2020-02-11T21:10:27Z

← Older revision		Revision as of 21:10, 11 February 2020
Line 27:		Line 27:

	===Regarding SQL Server 2019 Compatibility===		===Regarding SQL Server 2019 Compatibility===
	~~Our Data Quality Components work with~~ SSIS ~~2019 by setting~~ the ~~project to run on SSIS 2017~~.		We recommend SSIS 2016/2017 for the most stable environment for our components.

	We ~~have found that using SSIS 2017 or SSIS 2016 is more stable than using~~ SSIS 2019 ~~with backwards compatibility~~.		We are working on updating our Data Quality Components to work natively on SSIS 2019.

	~~We are working on updating our Data Quality Components to work natively on SSIS 2019.~~ Please check back on this page for future news on SSIS 2019 compatibility.		Please check back on this page for future news on SSIS 2019 compatibility.