What is the RPC and RPC Out option on a SQL Server linked-server?

Someone asked me this week – what are the relevance of the RPC and RPC Out settings on a linked server? Do you need both of them or only one of them set to True? The documentation is online in this article, but it doesn’t clearly show examples or provide enough context, so I will try…

2

SSIS error when deploying from VS 2013 to SSISDB in SQL 2012

An SSIS package has been developed in SSDT-BI Microsoft Visual Studio Professional 2013 (freely available download). When we deploy the package to SSISDB in SQL Server 2012 RTM or SP1 (11.0.3153.0) and run it, it returns the following error, because the SSIS 2014 package format is not downgradable to SSIS 2012 version format.  “The package failed…

4