title: SSIS: Passing parameter in OLE DB Source Editor to a table-valued function
body: <p>How can I pass parameters in an OLE DB Source to call a table-valued function like:</p>
  
  <blockquote>
    <p>select * from [dbo].[udf_test](?, ?)</p>
  </blockquote>
  
  <p>When doing so, I am getting the error: </p>
  
  <p><em>Parameters cannot be extracted from the SQL command. The provider might not help to parse parameter information from the command. In that case, use the "SQL command form variable" access mode, in which the entire SQL command is stored in a variable.
  Syntax error, permission violation, or other nonspecific error (Microsoft SQL Native Client)</em></p>
  
  <p>Is there another solution than "SQL command from variable"?</p>
  
  <p>Sven</p>