FAQ:SSIS:Target Server Version Option

From Melissa Data Wiki
Jump to navigation Jump to search

← 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.
    SSIS TSV-Step2.png

  2. Select Configuration Properties. You will see the Target Server Version; select the desired version of SQL Server.
    SSIS TSV-Step3.png

  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.
    SSIS TSV-Step4.png