SSIS to import from datalake to azure sql db

Question

Hi All,

We have third party extracts(csv fiels) into Azure Datalake.

I need to import these Azure SQL DB. We have very very small budgets and can't use ADF.

Can we use SSIS to do this?

What is the solution?

Thanks

Answer 1

Please use Azure Feature Pack for SSIS to connect to Azure Data Lake. You can use OLDB or ODBC connection manager to get connected to Azure SQL Database.