title: Azure Data Factories vs SSIS
body: <p>I am thinking of moving our SSIS ETLs to Azure Data Factory. My arguments in favour of such leap are:</p>
  
  <ul>
  <li><p>Our sources and targets are already in the cloud. ADF is cloud native so it seems at good fit.</p></li>
  <li><p>ADF is a service are therefore we could consume and pay for it on demand. SSIS implies licensing costs, and doesn't lend  lend it itself naturally for on-demand consumption (we thought of using DevOps to spin ETL servers on an ad-hoc basis)</p></li>
  <li><p>Generating ETL code programmatically with SSIS requires very specific skills such as BIML or the DTS API. By moving to ADF I am hoping the combination of JSON and the TSQL and C# in USQL will make the necessary skills more generic.</p></li>
  </ul>
  
  <p>I am hoping members of the community can share their experiences and thus help me come to a decision.</p>