Lift Azure SSIS to adf , Can we mount blob storage in SSIS integration Runtime

Thangamuthu, Vignesh 20 Reputation points
2024-04-17T09:51:44.3966667+00:00

In SSIS we are reading multiple files from D:(local drive)

In azure all the file are available in blob

Is it possible to mount blob storage with ssis integration run time? so that with minimal changes we can do lift and shift or else we need to work every place where flat file source and destination .

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,567 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
495 questions
0 comments
Accepted answer
  1. Amira Bedhiafi 15,446 Reputation points
    2024-04-17T10:43:22.7233333+00:00

    Directly mounting Blob storage as a drive (like in your case D:) in SSIS IR isn't supported. SSIS does not natively understand Azure Blob storage as a filesystem.

    I think with the Azure Feature Pack for Integration Services, which includes tasks and components that allow SSIS to connect and work with Azure services like Blob storage, you will be able to use the Azure Blob Source and Destination components to read from and write to Blob storage.

    So you can modify your existing SSIS packages to replace file paths with Azure Blob storage paths.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest