title: Read file in SSIS Project into a variable
body: <p>My SSIS projects tend to run queries that require changes as they move between environments, like the table schema might change or a value in the Where clause.  I've always either put my SQL into a Project Parameter, which is hard to edit since formatting is lost, or just put it directly into the Execute SQL Task/Data Flow Source then manually edited it between migrations which is also not ideal.  </p>
  
  <p>I was wonder though if I added my SQL scripts to files within the project, can these be read back in?  Example if I put a query like this:
  select id, name from %schema%.tablename
  I'd like to read this into a variable then it's easy to use an expression as I do with Project Parameters to replace %schema% with the appropriate value.  Then the .sql files within the project can be edited with little effort or even tested through an Execute SQL Task that's disabled/removed before the project goes into the deployment flow. But I've been unable to find how to read in a file using a relative path within the project.  Also I'm not even sure these get deployed to the SSIS Server. </p>
  
  <p>Thanks for any insight.</p>
  
  <p>I've added a text file query.sql to an SSIS (SQL 2017) Project in Visual Studio, bit I've found no way to pull the contents of query.sql into a variable.</p>