title: Executing SQL File in SSIS
body: <p>I am using Microsoft Visual Studio 2010 currently. I have a .sql file on my computer which has a lot of sql statements of code in it. Basically has three create table statements, multiple insert into statements, multiple alter table statements,adding foreign keys, etc.</p>
  
  <p>I want to know is there a way that I can load that .sql file into an Execute SQL Task. Or how is it possible, in SSIS, that I can execute this long .sql file? I feel like an Execute SQL Task is involved, but I don't know for sure. This was the Execute SQL Task I tried before to no avail. <a href="https://i.stack.imgur.com/VFX9R.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VFX9R.png" alt="enter image description here"></a></p>
  
  <p>Any help would be appreciated.</p>
  
  <p>I have some screenshots basically to show how long of a file I'm talking about...and it goes longer than what is shown.</p>
  
  <p><a href="https://i.stack.imgur.com/L8ntk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/L8ntk.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/ExgED.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ExgED.png" alt="enter image description here"></a></p>