I have an SSIS project that I've been working on. I've moved to a new workstation, and when I try and run the SSIS packages from VS 2015 on this new workstation, they immediately complete with out doing any work. The progress log remains blank, and the output log only shows two lines:
SSIS package "C:\MyFolder\MyPackage.dtsx" starting.
SSIS package "C:\MyFolder\MyPackage.dtsx" finished: Canceled.
I can deploy the packages to SQL Server, and they run fine. Other SSIS projects on this workstation run without issue, and running these problem packages from other workstations also work without issue.
Anyone have any idea what might be the issue, and/or tips for how I can troubleshoot this?
Final solution ended up being mis-matched versions of the Attunity Connector for Oracle.
On the new workstation, I had only installed version 4.0. Once I installed versions 3.0 and 2.0 as well, the packages began to run without issue. This is even though most of the packages I was testing didn't user the Attunity connector. Just having an MSORA connection manager in my project was enough to bring the whole thing crashing down.
Moral of the story: Even though v4.0 is required to be installed to allow the designer in VS2015 to access and use the connector/Sources/Destinations, you still need the version specific to the SSIS TargetServerVersion that you're using installed as well.