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
 
(One intermediate revision by the same user not shown)
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.


<!--:[[File:.png|link=]]-->
#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.
2. 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-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:.png|link=]]-->
#:[[File:SSIS_TSV-Step4.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]]

Latest revision as of 23:24, 29 March 2022

← SSIS:Data Quality Components


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.

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


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


  3. 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.
Retrieved from "http://wiki.melissadata.com/index.php?title=FAQ:SSIS:Target_Server_Version_Option&oldid=18594"