perhaps the one or more of the data models on this site will provide you with ideas

http://www.databaseanswers.org/data_models/

question should have stated select more than one

and the error is ?

Have you tried changing the property pages for an Integration Services project, on the General tab of Configuration Properties, select the TargetServerVersion property and choose SQL Server 2016, SQL Server...

SQL Server 2008 is not supported on Windows 10.

https://support.microsoft.com/en-us/kb/2681562

edit the dtxs files in a text editor

see attached for an example of the package path

not sure this will work since SSDT-BI 2013 is not backward-compatible with SQL Server 2012, but you might try the suggestions listed in the link below

https://vaniecastro.com/2015/02/26/how-to-downgrade-sql-server-integration-services-2014-packages-to-2012/

I have not experienced this error, but found the link below which describes the error you receive and steps to correct.

https://blogs.msdn.microsoft.com/dataaccesstechnologies/2014/05/21/ssis-package-fails-with-error-the-step-did-not-generate-any-output-the-return-value-was-unknown/

recommend reading Joe Sack's write up on this

http://www.sqlskills.com/blogs/joe/spilltotempdb-warning-and-spilllevels-mapping-to-single-versus-multiple-pass/

have you tried using the “Balanced Data Distributor” for SSIS?

https://blogs.msdn.microsoft.com/sqlperf/2011/05/25/the-balanced-data-distributor-for-ssis/

the balanced data distributor works with ADO.net connections

usually with MultipeActiveResultSets and increased packet size

Suggest changing the destination connection advanced property for MultipleActiveResultSets to True

try

May be totally unrelated, but have seen indexed views on two tables cause deadlock on queries that only reference one of the tables - similar to what you described.

try looking here for examples

http://www.databaseanswers.org/data_models/

these articles provide the basics for writing SSIS Script Task -- C#.Net & VB.Net

includes executing sql statement with multiple results

http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/76439/

http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/76438/