This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 46%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
I have used a azure SSIS IR to execute my SSIS package from on premise to azure adf but its failing as we epplus dll are used in script task of SSIS packages and same I tried to add using main.cmd but still facing issue in this .
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 9%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hi @Khatri, Ashish ,
Welcome to Microsoft Q&A Platform. Thanks for posting the query.
Can you please share the error message and pipeline run id information which will help us to assist in further investigation of the issue.
Looking forward for your response!
Hi @Khatri, Ashish ,
We have not received a response from you. Are you still facing the issue? If you found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.
@HarithaMaddi-MSFT
HarithaMaddi-MSFT avatar imageHarithaMaddi-MSFTFollow
9626
Reputation
1242
Posts
9
Following
5
Followers
I copied dll to azure SSIS IR and because of port 443 closed on my machine I am not able to setup UNC path any other work around to connect azure file share to Azure SSIS IR.
Thanks @Khatri, Ashish for sharing more details. I will check with internal teams and will get back to you as soon as I hear from them.
Hi @Khatri, Ashish ,
Can you please elaborate more on the ask here. Please share where the dlls are installed and the use case here to connect to azure file share from azure ssis IR. Does it mean that DLLs are available in fileshare? Please suggest the reason for host machine here as Azure SSIS IR is managed by Microsoft and need not install it in machine.
Also, please refer this document for additional details.
Looking forward for more details!
Hi @Khatri, Ashish ,
We have not received a response from you. Are you still facing the issue? If you found a solution, would you please share it here with the community? Otherwise, let us know more details as requested above and we will continue to engage with you on the issue.
Yes @HarithaMaddi-MSFT I haVE USED MAIN.CMD file for custom configuration of azure SSIS IR and same settings are now installed on both the AZURE SSIS IR nodes. I referred Microsoft Learn for better understanding.
configure-azure-ssis-ir-custom-setup#:~:text=%20To%20customize%20your%20Azure-SSIS%20IR,%20you%20need,setups,%20you%20upload%20and%20store%20your...%20More
Thanks @Khatri, Ashish for confirming the details. However, your comments above stated the challenge in opening port 443, can you please elaborate where you are trying to open the port.
Actually Azure file share mount needs port 443 to be open and in my case its closed due to security issues or company policies so I requested out IT team to open the same and now I am able to mount the azure file share with my machine.
Thanks @Khatri, Ashish for sharing the cause and solution to the same.
--
Hi @Khatri, Ashish ,
We have not received a response from you. Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.