/* try this - it may not make a difference but it might help you find the bottleneck */

;with cte as

(

select a.*

from tbl_documents AS a

inner...

Let me rephrase my original question.

Hello,

I know how to "Create and map a Server Environment" using management studio (https://msdn.microsoft.com/en-us/library/hh213230(v=sql.110).aspx).

Is it possible to create the environment in Integration...

The following link describes a method that successfully passes by reference from child package to parent package

http://www.hitmaroc.net/818174-3316-ssis-2012-pass-values-child-package-parent-project-deployment-model.html

Obviously I should have made myself much clearer from the start.

My predecessor ported an SSIS solution to 2012. It contained 8 packages. By default the solution was encrypted...

An inherited SSIS (2012) solution displays the following messages when I try opening it in VS 2012:

"One or more projects in the solution were not loaded correctly."

Then another message...

I need access to the solution to modify it.

Thanks but I need to get to the source.