title: SSIS and dll using Entity Framework
body: <p>I have a .net dll which contains business logic that I want to re-use in an SSIS package. The dll uses Entity Framework for its data access layer. I found a way to load the dlls at run-time (<a href="https://blogs.msdn.microsoft.com/dbrowne/2014/06/25/how-to-load-an-assembly-in-a-ssis-script-task-that-isnt-in-the-gac/" rel="nofollow">How to load an Assembly...</a>) but I keep getting errors which boil down to not having a valid connection string. Normally in our EF applications, the connection string is in the app.config file, and EF loads it automatically. However, I cannot find a way to add a config file to an SSIS package. Does anyone have an idea of how I might be able to add a config file, or set a connection string, so that an EF based dll can use it? </p>
  
  <p>I am using VS 2012, and SQL Server 2012, EF 6.0 and .Net Framework 4.52</p>