We plan to migrate the DB server from SQL VM to a managed instance. And previously the input files (csv) for the SSIS packages were kept in some drive location (like C: E:) since it was VM. But now we are moving to the managed instance and it is serverless. So we are planning to place the input files in Azure file storage but in SSIS there are no default connection managers to connect the Azure file storage. So kindly advise that how to fetch the input files from Azure file storage through SSIS packages.
To use Azure Files, and you simply set the credentials to use:
catalog.set_execution_credential @domain = N'Azure', @user = N'<storage-account-name>', @password = N'<storage-account-key>'
And replace the drive letter with a UNC path, and use the same connectors you would for the local file system.