title: Azure Synapse with SSIS package
body: <p>I have used several Azure services to upload data from on-premises to Azure SQL DW for Power BI.</p>
  <pre><code>SQL Server (On Perm) -&gt; Azure Data Factory (SSIS IR, SSIS in Azure SQL Database) -&gt; Azure SQL Database&lt;br/&gt;
  2 Azure services used
  </code></pre>
  <p>However, we find that the data size is growing much bigger than design the platform.<br/>
  We are planning to change to Azure Synapse.</p>
  <p>But based on Microsoft Documentation, it seems the Data Factory (Preview) did not come with SSIS IR.<br/>
  Here is what come up on my mind:</p>
  <pre><code>SQL Server (On Perm) -&gt; Azure Data Factory (SSIS IR, SSIS in Azure SQL Database) -&gt; Azure Synapse&lt;br/&gt;
  3 Azure services used
  </code></pre>
  <p>I wonder does it have a better way for Synapse with SSIS.</p>
  <p>Many thanks.</p>