Hi

I have deployed a SSDT 2012 package to the SSIS store and trying to run it on a SQL cluster. My SQL team say that they installed SSIS & SSDT (as per the URL below) on the nodes but I am still getting the error, 'to run ssis outside of SSDT you must install file system task of integration service or higher'.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/37c14b09-143f-47d7-a6f5-dc591cd4b690/to-run-ssis-package-outside-of-sql-data-tools?forum=sqlintegrationservices

The SQL version generated by the package is 11.0.61030 & the cluster version is 11.0.5058, is this the problem or are there other steps to perform?

Thanks

SSDT is not needed to run deployed packages

I sense you abridged the error message significantly, but the issue is with the SSIS edition.

E.g. the Prod Environment is on SQL Server 2012 Standard (run SELECT @@VERSION to determine), but your package was developed using SQL Server Developer edition that equals Enterprise and used a component not available in the Std edition.

Thanks for the reply.

full error message: "To run a SSIS package outside of SQL data Tools you must install File System Task of Integration Services or higher".

DB Version: SQL Server 2012 - 11.0.5058 Enterprise Edition (64 bit)

VS : Visual Studio 2012 Shell (integrated) version 11.0.61030.0, with SSDT.

Thanks