title: Azure Data Factory Lookup Activity, Stored Procedure with Table Type parameter
body: <p>I'm setting up an Azure Data Factory to copy DB data between 2 Azure SQL Server. </p>
  
  <p>I have a Stored Procedure at sink DB and SP has a user-defined table type parameter and some OUTPUT parameters.</p>
  
  <p>I've succeeded with Copy Activity but found that OUTPUT parameters are not supported.
  (<a href="https://social.msdn.microsoft.com/Forums/azure/en-US/82e84ec4-fc40-4bd3-b6d5-b742f3cd1a33/adf-v2-how-to-check-if-stored-procedure-output-is-empty?forum=AzureDataFactory" rel="nofollow noreferrer">https://social.msdn.microsoft.com/Forums/azure/en-US/82e84ec4-fc40-4bd3-b6d5-b742f3cd1a33/adf-v2-how-to-check-if-stored-procedure-output-is-empty?forum=AzureDataFactory</a>)</p>
  
  <p>So I tried with two Lookup Activity, one is to select multiple rows from the table(maybe into my table type), another is to execute SP. </p>
  
  <p>But when setting the second Lookup Activity, there's no Table Type parameter setting with Stored Procedure Parameter.</p>
  
  <p>Pressing "Import parameter" also didn't show a table type parameter.</p>
  
  <p>How can I pass a table type parameter from lookup activity 1 to the second?</p>