Share via

SSIS to import from datalake to azure sql db

rajanisqldev-42 221 Reputation points
2022-09-08T08:14:46.18+00:00

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

Azure SQL Database
Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,559 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
0 comments
Accepted answer
  1. Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator
    2022-09-08T12:25:50.047+00:00

    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.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.