FAQ:SSIS:Target Server Version Option: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
Created page with "← SSIS:Data Quality Components {{CustomTOC}} ==Setting the Target Server Version Option== 1. In Visual Studio, verify that the Target Se..."
 
No edit summary
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]]

Revision as of 23:18, 29 March 2022

← SSIS:Data Quality Components


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.


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.