title: ssis - No value given for one or more required parameters
body: <p>I am working with SSIS 2008. i am getting error on sql task editor
  query as Error: Executing the query "SELECT  SUBSTRING(?, 8, 2) + SUBSTRING(?, 10, 2) +..." failed with the following error: "No value given for one or more required parameters.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.</p>
  
  <p>Execute sql task containing query</p>
  
  <p>SELECT  SUBSTRING(?, 8, 2) + SUBSTRING(?, 10, 2) + '20' + SUBSTRING(?, 10, 2) AS File_Date</p>
  
  <p>i had selected result_Set as Single_row</p>
  
  <p>The parameter mapping used containing field name as
  var_name:User::File_Name_update 
  direction:input
  Data type: varchar
  parameter_name:0
  Parameter_size:-1</p>
  
  <p>The result set i have added is:
  Result_Name:File_date
  variable_name:User::File_date</p>
  
  <p>So here i am getting the file date from the updated input file name in substring.May i know what am i doing wrong to handle the above scenario?</p>