SSDT2012 version SSIS package can be execute on SQL Server 2012?

Question

I have upgraded my VS2005 - SSIS project to VS 2013 (SSDT2012). And I am using SQL Server 2012. Where I need to execute SSIS package using Integration Service Catalog for SQL Server job. But I get some error and I got to know that SSDT-2012 version can not be execute in SQL Server 2012.

I don't have any chance to downgrade SSIS package version. So is there any other way to execute a SSDT-2012 SSIS package in a SQL Server 2012 job?

Suggestions are most welcome.

Answer 1

If you want to build SQL Server 2012 ssis packages you need to install SQL Server Data Tools for Visual Studio 2015 or SQL Server Data Tools - Business Intelligence for Visual Studio 2012. SQL Server Data Tools - Business Intelligence for Visual Studio 2013 is used to build ssis packages for SQL Server 2014 only.

References

• Installing Integration Services Versions Side by Side
• SSIS tag wiki