title: Issues when using SSIS Execute SQL Task to insert a row into SQL Server with multiple parameters
body: <p>I am trying to use SSIS to insert a row with multiple parameters but I get this error :</p>
  
  <blockquote>
    <p>[Execute SQL Task] Error: Executing the query "insert into ids (id,sqljobname,ojobname,ojobstartd..." failed with the following error: "The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.</p>
  </blockquote>
  
  <p>This is how I set up the Execute SQL Task:</p>
  
  <pre><code>insert into ids (id, sqljobname, ojobname, ojobstartdate)
  values (?, ?, ?, ?)
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/JRdEq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JRdEq.png" alt="enter image description here"></a></p>
  
  <p>Please let me know where I set it up wrong. I don't think the ParentJobStartDate is an issue because I set it up with string.</p>