So far, you would need to create ADF pipelines, activities etc. to implement ETL tasks on Azure. But If you are SQL Server Integration Services (SSIS) fun like me and want to use SSIS packages on Azure, you would need to run your SQL Server Integration Services (SSIS) packages on your own SQL Server running on an Azure VM. With Azure Data Factory v2 (currently in preview) ,  ADF can run your SSIS packages. So you lift and shift your SSIS packages 🙂 Details are in the link below :

https://docs.microsoft.com/en-us/sql/integration-services/lift-shift/ssis-azure-lift-shift-ssis-packages-overview

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>