I have a SSIS package that works fine from VS2015 but when I try to run it from SSMS it fails with the error:
To run a SSIS package outside of SQL Server you must install conditional split of integration services or higher.
I did a little research and also created a new package with only a source and destination which worked fine. Once I added the conditional split it failed again. It seems like this may be a version conflict between the data tools, SSIS and SQL Server. I have other packages with conditional splits and other tasks that are executed in SQL Server such as Execute SQL tasks. The only reason I can think that they work is because they were created in a previous version of SSIS then upgraded.
I am using Visual Studio 2015 Community with
SQL Server Data Tools 14.0.61021.0
SQL Server Integration Services Designer 13.0.1701.8
On the SQL Server it says the SSIS version is 12.0.2269
My version of management Studio is 12.0.2000.8
I am just having a hard time finding out what versions are required to work. Do I need a different version of SSIS to coincide with SSDT?