title: How to call stored procedure on Teradata with SSIS sql execution task?
body: <p>I have a problem with calling a stored procedure with parameter on Teradata. I use SSDT 2015 and Teradata 15.10.1.10. The stored procedure has one parameter: <code>in VALID_FROM varchar(10)</code></p>
  
  <p>To escape date-conversion problems I choose to make input variable with type varchar and then inside the stored procedure I make conversion <code>cast(VALID_FROM as date)</code> and use it in queries.</p>
  
  <p>So, I have two blocks is SSIS:
  1) "GetInputParameter" (SQL execution task) that returns string with date.
  2) "ExecuteProcedureOnDest" (SQL execution task) that calling stored procedure on Teradata through ODBC driver.</p>
  
  <p>I checked that input parameter is a string with format 'YYYY-MM-DD', so it seems to me, that everything is ok. But when I run the package, I see an error on task "ExecuteProcedureOnDest":</p>
  
  <blockquote>
    <p>[Teradata][ODBC Teradata Driver][Teradata Database]
    SPINTORGLISTPREPARE:Invalid date.</p>
  </blockquote>
  
  <p>I will be very grateful for help in solving this problem!</p>