title: Failed to create an IDataAdapter object. This provider may not be fully supported with the Execute SQL Task
body: <p>I executed a simple query inside an execute SQL task - </p>
  
  <pre><code>SELECT col1, col2
  from thetable
  where code = ?
  order by id asc
  </code></pre>
  
  <p>Exec sql task - ADO.NET connection
  parameter "code" is an int32 in SSIS and int32 in parameter mapping of exec sql task.</p>
  
  <p>It works fine in SQL server, but in SSIS it causes the error - </p>
  
  <p>[Execute SQL Task] Error: Executing the query "SELECT col1, col2
  from thet..." failed with the following error: "Failed to create an IDataAdapter object. This provider may not be fully supported with the Execute SQL Task. Error message 'Incorrect syntax near '?'.'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.</p>
  
  <p>How do I fix this error ? </p>