FAQ:SSIS:Target Server Version Option
← 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.
- To set the Target Server Version, in Visual Studio’s Solution Explorer, right click on the SSIS project Node and click Properties.
- Select Configuration Properties. You will see the Target Server Version; select the desired version of SQL Server.
- 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.