FAQ:SSIS:Target Server Version Option - Revision history

Admin at 23:24, 29 March 2022

2022-03-29T23:24:45Z

← Older revision		Revision as of 23:24, 29 March 2022
Line 3:		Line 3:

	==Setting the Target Server Version Option==		==Setting the Target Server Version Option==
	#In Visual Studio, verify that the Target Server Version option is set to the corresponding SQL Server instance on the machine.		In Visual Studio, verify that the Target Server Version option is set to the corresponding SQL Server instance on the machine.

	#To set the Target Server Version, in Visual Studio’s Solution Explorer, right click on the SSIS project Node and click '''Properties'''.		#To set the Target Server Version, in Visual Studio’s Solution Explorer, right click on the SSIS project Node and click '''Properties'''.
	#:[[File:SSIS_TSV-Step2.png\|link=]]<br/><br/>		#:[[File:SSIS_TSV-Step2.png\|link=]]<br/><br/>
Line 10:		Line 11:
	#Once set, the project will reload. Double click the .dtsx package in the Solution Explorer menu and our SSIS components should appear in the SSIS Toolbox.		#Once set, the project will reload. Double click the .dtsx package in the Solution Explorer menu and our SSIS components should appear in the SSIS Toolbox.
	#:[[File:SSIS_TSV-Step4.png\|link=]]		#:[[File:SSIS_TSV-Step4.png\|link=]]


	~~:Melissa’s SSIS Enterprise level components can process hundreds of thousands of records per hour.~~

	~~:SSIS is available in 2 processing modes, '''Cloud''' and '''On Premise''', which will affect throughput speeds.~~


	[[Category:FAQ]]		[[Category:FAQ]]
	[[Category:SSIS:Data Quality Components]]		[[Category:SSIS:Data Quality Components]]

Admin at 23:18, 29 March 2022

2022-03-29T23:18:30Z

← Older revision		Revision as of 23:18, 29 March 2022
Line 3:		Line 3:

	==Setting the Target Server Version Option==		==Setting the Target Server Version Option==
	1. In Visual Studio, verify that the Target Server Version option is set to the corresponding SQL Server instance on the machine.		#In Visual Studio, verify that the Target Server Version option is set to the corresponding SQL Server instance on the machine.
			#To set the Target Server Version, in Visual Studio’s Solution Explorer, right click on the SSIS project Node and click '''Properties'''.
			#:[[File:SSIS_TSV-Step2.png\|link=]]<br/><br/>
			#Select '''Configuration Properties'''. You will see the Target Server Version; select the desired version of SQL Server.
			#:[[File:SSIS_TSV-Step3.png\|link=]]<br/><br/>
			#Once set, the project will reload. Double click the .dtsx package in the Solution Explorer menu and our SSIS components should appear in the SSIS Toolbox.
			#:[[File:SSIS_TSV-Step4.png\|link=]]

	~~<!--:[[File:.png\|link=]]-->~~

			:Melissa’s SSIS Enterprise level components can process hundreds of thousands of records per hour.

	2~~. To set the Target Server Version, in Visual Studio’s Solution Explorer~~, ~~right click on the SSIS project Node and click~~ '''~~Properties~~'''.		:SSIS is available in 2 processing modes, '''Cloud''' and '''On Premise''', which will affect throughput speeds.

	~~<!--:[[File:.png\|link=]]-->~~


	~~3. Select~~ '''~~Configuration Properties~~'''~~. You will see the Target Server Version; select the desired version of SQL Server.~~

	~~<!--:[[File:.png\|link=]]-->~~


	~~4. Once set~~, ~~the project~~ will ~~reload. Double click the .dtsx package in the Solution Explorer menu and our SSIS components should appear in the SSIS Toolbox.~~

	~~<!--:[[File:~~.~~png\|link=]]-->~~


	[[Category:FAQ]]		[[Category:FAQ]]
	[[Category:SSIS:Data Quality Components]]		[[Category:SSIS:Data Quality Components]]

Admin: Created page with "← SSIS:Data Quality Components {{CustomTOC}} ==Setting the Target Server Version Option== 1. In Visual Studio, verify that the Target Se..."

2022-03-09T01:30:04Z

Created page with "← SSIS:Data Quality Components {{CustomTOC}} ==Setting the Target Server Version Option== 1. In Visual Studio, verify that the Target Se..."

New page

[[SSIS:Data Quality Components|← SSIS:Data Quality Components]]
{{CustomTOC}}

==Setting the Target Server Version Option==
1. In Visual Studio, verify that the Target Server Version option is set to the corresponding SQL Server instance on the machine.



2. To set the Target Server Version, in Visual Studio’s Solution Explorer, right click on the SSIS project Node and click '''Properties'''.



3. Select '''Configuration Properties'''. You will see the Target Server Version; select the desired version of SQL Server.



4. Once set, the project will reload. Double click the .dtsx package in the Solution Explorer menu and our SSIS components should appear in the SSIS Toolbox.



[[Category:FAQ]]
[[Category:SSIS:Data Quality Components]]