LaunchSSIS2012-VS2015

Launch ssis from VB.net code using sql 2012 and VS 2015

Primary goals

Use SQL 2012 with SSIS (Special needs, SP 2 CU1-6+SEC 1)
VS 2015
Visual Basic
Launch SSIS package from file locally
Windows 7 Enterprise

Other thoughts

Does SSIS have to be 2012?

We're connecting remotely to a sql 2012 server. Seems like we could use whatever SSIS we wanted locally.

Environment Setup

Setup new VM 4 gigs ram, 4 CPU
Install Win 7 Enterprise SP 1
Install SQL 2012 SP2 Developer Edition
- Database engine
- MGMT tools (all)
- Client Connectivity
- Client Connectivity SDK
Install VS 2015
- Git
- Web Apps
- SSDT (SQL Server Data Tools)
Install SSDT for VS 2015 version 17.4 "SSDT for VS2015 17.4" found at https://docs.microsoft.com/en-us/sql/ssdt/previous-releases-of-sql-server-data-tools-ssdt-and-ssdt-bi?view=sql-server-2017

Key Challenges

Mismatch of .net version to the Managed DTS runtime. v2 vs v4.5. This article was key: https://stackoverflow.com/questions/29240142/mixed-mode-assembly-is-built-against-version-v2-0-50727-of-the-runtime-and-can/29241003#29241003
Target SSIS version should/must be changed from SQL 2017 to SQL 2012