title: How to load files from blob to sql dw by using azure data factory?
body: <p>I have tried so many ways to load data from :</p>
  <ol>
  <li><p>Azure blob to azure SQL synapse.</p>
  <p>My requirement is :<br />
  Description:</p>
  <pre><code> (Input)Blob storage ---&gt;  Azure sql synapse(Output)
                  emp_dummy.csv----&gt; emp_dummy table
                  dept_dummy.csv -----&gt; dept_dummy table
                  sales_dummy.csv-----&gt; sales_dummy table   and so on
  </code></pre>
  </li>
  </ol>
  <p>...</p>
  <p>We have files starting with different names but the format is .csv only.
  I have been trying this in various ways by using <code>getmetadata</code> activity or lookup activity.</p>
  <p>When I tried with the below activity, facing the error:
  [ADF pipeline][1]
  [1]: https://i.stack.imgur.com/RynIb.png
  Error:</p>
  <pre><code>{
      &quot;errorCode&quot;: &quot;2200&quot;,
      &quot;message&quot;: &quot;ErrorCode=UserErrorMissingPropertyInPayload,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Required property 'fileName' is missing in payload.,Source=Microsoft.DataTransfer.ClientLibrary,'&quot;,
      &quot;failureType&quot;: &quot;UserError&quot;,
      &quot;target&quot;: &quot;Copy data1&quot;,
      &quot;details&quot;: []
  }
  </code></pre>
  <p>I hope, I mention all details, if need some more, let me know.</p>