FAQ:SSIS:Data Quality Components - Revision history

Admin at 22:27, 20 August 2020

2020-08-20T22:27:45Z

← Older revision		Revision as of 22:27, 20 August 2020
Line 111:		Line 111:
	==What Versions of SQL Server/Visual Studio Is Your Components Supported in?==		==What Versions of SQL Server/Visual Studio Is Your Components Supported in?==
	;Answer:		;Answer:
	:Melissa Data currently supports ~~2008,~~ 2012, 2014, and ~~2016 versions of SQL Server~~. We also provide components for SQL Server 2005 as part of the SSIS Installation, however, ~~it is~~ no longer supported~~. Certain Microsoft SQL Server version are supported by specific Microsoft Visual Studio versions for our components. BusinessCoder and future new component will only be offered in SSIS 2010+~~.		: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.

	*Microsoft SQL Server 2016 - Microsoft Visual Studio 2015~~/SSDT~~(~~VS2015 Shell~~)		: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 2014 - Microsoft Visual Studio 2013
	*Microsoft SQL Server 2012 - Microsoft Visual Studio 2010/2012		*Microsoft SQL Server 2012 - Microsoft Visual Studio 2010/2012
	*Microsoft SQL Server 2010 - Microsoft Visual Studio 2008		*Microsoft SQL Server 2010 - Microsoft Visual Studio 2008 - '''Deprecated'''
	*Microsoft SQL Server 2008 - Microsoft Visual Studio 2005		*Microsoft SQL Server 2008 - Microsoft Visual Studio 2005 - '''Deprecated'''
	[[Category:FAQ]]		[[Category:FAQ]]
	[[Category:SSIS:Data Quality Components]]		[[Category:SSIS:Data Quality Components]]

Admin at 16:28, 31 December 2019

2019-12-31T16:28:51Z

← Older revision		Revision as of 16:28, 31 December 2019
Line 54:		Line 54:
	::If the input data is really corrupted or having lot of errors, will effect the performance.		::If the input data is really corrupted or having lot of errors, will effect the performance.

	We have additional 2 different scenarios for using EVC, which will help you to analyse the throughput of the component in different situations. ~~For more information you can click on following link:~~		We have additional 2 different scenarios for using EVC, which will help you to analyse the throughput of the component in different situations.
	~~[http://www.melissadata.com/ssis1/SSIS-Speed-Scenarios.pdf SSIS Speed Scenarios]~~

	==Profiler Speed?==		==Profiler Speed?==

Admin at 23:36, 23 August 2017

2017-08-23T23:36:28Z

← Older revision		Revision as of 23:36, 23 August 2017
Line 56:		Line 56:
	We have additional 2 different scenarios for using EVC, which will help you to analyse the throughput of the component in different situations. For more information you can click on following link:		We have additional 2 different scenarios for using EVC, which will help you to analyse the throughput of the component in different situations. For more information you can click on following link:
	[http://www.melissadata.com/ssis1/SSIS-Speed-Scenarios.pdf SSIS Speed Scenarios]		[http://www.melissadata.com/ssis1/SSIS-Speed-Scenarios.pdf SSIS Speed Scenarios]

			==Profiler Speed?==
			:Different analysis features directly affect component performance. Options with data aggregation and sort analysis have a high impact on speed of the component. For a list of speed tests, see [[SSIS:Profiler:FAQ#Service Speed\|Profiler FAQ Service Speed]].

	==How do I make Excel Source Drivers work?==		==How do I make Excel Source Drivers work?==

Admin at 21:20, 22 December 2016

2016-12-22T21:20:54Z

← Older revision		Revision as of 21:20, 22 December 2016
Line 109:		Line 109:
	==What Versions of SQL Server/Visual Studio Is Your Components Supported in?==		==What Versions of SQL Server/Visual Studio Is Your Components Supported in?==
	;Answer:		;Answer:
	:Melissa Data currently supports 2008, 2012, and ~~2014~~ versions of SQL Server. We also provide components for SQL Server 2005 as part of the SSIS Installation, however, it is no longer supported. Certain Microsoft SQL Server version are supported by specific Microsoft Visual Studio versions for our components. BusinessCoder and future new component will only be offered in SSIS 2010+.		:Melissa Data currently supports 2008, 2012, 2014, and 2016 versions of SQL Server. We also provide components for SQL Server 2005 as part of the SSIS Installation, however, it is no longer supported. Certain Microsoft SQL Server version are supported by specific Microsoft Visual Studio versions for our components. BusinessCoder and future new component will only be offered in SSIS 2010+.

	*Microsoft SQL Server 2016 - Microsoft Visual Studio 2015/SSDT(VS2015 Shell)		*Microsoft SQL Server 2016 - Microsoft Visual Studio 2015/SSDT(VS2015 Shell)

Admin at 17:15, 16 December 2016

2016-12-16T17:15:49Z

← Older revision		Revision as of 17:15, 16 December 2016
Line 32:		Line 32:
	==How do I enable On-Premise Global Verify?==		==How do I enable On-Premise Global Verify?==
	;Answer:		;Answer:
	:Please make sure that you have a valid ~~license key~~ that has the local processing enabled. Otherwise the on-premise settings in advanced configuration settings screen will not be visible. You need to set the countries that you want to be processed through locally, the other countries that is not selected will be processed through the Global Verify web service. Please make sure your datafile structures is correct and all datafiles is present, otherwise the dll may crash or reject your settings. When everything is set you can now enter the path for the root folder of your data files into the data path field. You can test to see if you have everything set correctly by pressing test configuration. The tester will report any issues that it finds with your setup. Please contact technical support if you are still having issues with your setup and we will gladly help you out.		:Please make sure that you have a valid License Key that has the local processing enabled. Otherwise the on-premise settings in advanced configuration settings screen will not be visible. You need to set the countries that you want to be processed through locally, the other countries that is not selected will be processed through the Global Verify web service. Please make sure your datafile structures is correct and all datafiles is present, otherwise the dll may crash or reject your settings. When everything is set you can now enter the path for the root folder of your data files into the data path field. You can test to see if you have everything set correctly by pressing test configuration. The tester will report any issues that it finds with your setup. Please contact technical support if you are still having issues with your setup and we will gladly help you out.

	==How come I can't process less than 100 records for SmartMover NCOA?==		==How come I can't process less than 100 records for SmartMover NCOA?==

Admin at 21:22, 26 October 2016

2016-10-26T21:22:21Z

← Older revision		Revision as of 21:22, 26 October 2016
Line 111:		Line 111:
	:Melissa Data currently supports 2008, 2012, and 2014 versions of SQL Server. We also provide components for SQL Server 2005 as part of the SSIS Installation, however, it is no longer supported. Certain Microsoft SQL Server version are supported by specific Microsoft Visual Studio versions for our components. BusinessCoder and future new component will only be offered in SSIS 2010+.		:Melissa Data currently supports 2008, 2012, and 2014 versions of SQL Server. We also provide components for SQL Server 2005 as part of the SSIS Installation, however, it is no longer supported. Certain Microsoft SQL Server version are supported by specific Microsoft Visual Studio versions for our components. BusinessCoder and future new component will only be offered in SSIS 2010+.

			*Microsoft SQL Server 2016 - Microsoft Visual Studio 2015/SSDT(VS2015 Shell)
	*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

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

2016-03-22T17:34:44Z

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

← Older revision		Revision as of 17:34, 22 March 2016
Line 109:		Line 109:
	==What Versions of SQL Server/Visual Studio Is Your Components Supported in?==		==What Versions of SQL Server/Visual Studio Is Your Components Supported in?==
	;Answer:		;Answer:
	:Melissa Data currently supports 2008, 2012, and 2014 versions of SQL Server. We also provide components for SQL Server 2005 as part of the SSIS Installation, however, it is no longer supported. Certain Microsoft SQL Server version are supported by specific Microsoft Visual Studio versions for our components.		:Melissa Data currently supports 2008, 2012, and 2014 versions of SQL Server. We also provide components for SQL Server 2005 as part of the SSIS Installation, however, it is no longer supported. Certain Microsoft SQL Server version are supported by specific Microsoft Visual Studio versions for our components. BusinessCoder and future new component will only be offered in SSIS 2010+.

	*Microsoft SQL Server 2014 - Microsoft Visual Studio 2013		*Microsoft SQL Server 2014 - Microsoft Visual Studio 2013

Oscar: /* What is affected during an install or upgrade */

2016-02-15T19:21:27Z

What is affected during an install or upgrade

← Older revision		Revision as of 19:21, 15 February 2016
Line 2:		Line 2:
	{{CustomTOC}}		{{CustomTOC}}

	==What is affected during an install or upgrade==		==What is affected during an install or upgrade?==
	;Answer:		;Answer:
	:By default the data is stored at this path: C:\Program Files\Melissa DATA\DQT\Data		:By default the data is stored at this path: C:\Program Files\Melissa DATA\DQT\Data

Oscar: /* What is affected during an install or upgrade */

2016-02-04T00:08:32Z

What is affected during an install or upgrade

← Older revision		Revision as of 00:08, 4 February 2016
Line 26:		Line 26:
	*Active Config Used by SSIS:		*Active Config Used by SSIS:
	**C:\ProgramData\Melissa DATA		**C:\ProgramData\Melissa DATA
			*Matchup Data Files and Configurations:
			**C:\ProgramData\Melissa DATA\MatchUP
			(mdMatchup.mc stores your matchcode and will not be overwritten if one exists, you can copy this to a new install to transfer matchcodes.)

	==How do I enable On-Premise Global Verify?==		==How do I enable On-Premise Global Verify?==

Oscar: /* What is affected during an install or upgrade */

2016-02-04T00:07:30Z

What is affected during an install or upgrade

← Older revision		Revision as of 00:07, 4 February 2016
Line 21:		Line 21:
	Affected During Update or Install:'		Affected During Update or Install:'
	*Component Pipeline Dlls:		*Component Pipeline Dlls:
	C:\Program Files\Microsoft SQL Server\110\DTS\Binn		**C:\Program Files\Microsoft SQL Server\110\DTS\Binn
	C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn		**C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn
	(Note That 110 refers to SQL SERVER 2012, please look for your corresponding version)		(Note That 110 refers to SQL SERVER 2012, please look for your corresponding version)
			*Active Config Used by SSIS:
			**C:\ProgramData\Melissa DATA

	==How do I enable On-Premise Global Verify?==		==How do I enable On-Premise Global Verify?==