SSIS:System Requirements: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| 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 | |||
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. | ||
===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 | ||
Revision as of 22:18, 20 August 2020
← SSIS:Data Quality Components
| SSIS Navigation | |||
|---|---|---|---|
| Introduction | |||
| System Requirements | |||
|
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).
- 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 2008 or newer
- 6 GB hard-disk space
- 4 GB RAM
Recommended Requirements
- 64-Bit Windows 10 or newer
- Microsoft SQL Server 2012 or newer
- 12 GB hard-disk space
- 8 GB RAM
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.
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.
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
- 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
- Microsoft SQL Server 2016 - Enterprise Edition and RC2 - Microsoft Visual Studio 2015
- 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 2012 - Microsoft Visual Studio 2010/2012
- Microsoft SQL Server 2010 - Microsoft Visual Studio 2008 - Deprecated
- Microsoft SQL Server 2008 - Microsoft Visual Studio 2005 - Deprecated