FAQ:SSIS:Target Server Version Option

From Melissa Data Wiki
Revision as of 23:18, 29 March 2022 by Admin (talk | contribs)
Jump to navigation Jump to search

← 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.