您好Aminesh， 

请检查以下链接：

使用在Azure中部署的SSIS包在本地和Azure中打开并保存文件

并查看它是否适用于您的情况。 

Hi All,

As a part of project requirement, I need to consume Excel File as a my source.

Now Client is using Azure VM Shared Folder to populate files in Shared folder.

Is it possible that I can read Excel file from On Prem machine to Azure VM Shared folder ?

If not then What are the other alternative I can ask client to provide file in Azure and I can consume Excel from On -Premise  ?

Ultimately I am shifting and lifting SSIs packages in ADF.

Hi Aminesh, 

Please check this link:

Open and save files on premises and in Azure with SSIS packages deployed in Azure

And see if it's working in your case.