How can I access the file share from ETL?
Here are my environment details:
- I have 2 nodes in a windows cluster. node 01 and node 02
- SQL Server 2014 is installed on both the nodes.
- Both are Windows Server 2012 R2 machines
- I have file share created in Azure portal and mapped as G: in both the nodes (01 and 02)
My ETL package is using C# code. It wants to read and write files on one shared folder for processing. I want it to use shared drive G.
Problem Statement: One of the nodes can be down at any time, so I cannot hard code as below:
Can I use file share feature (role) in a failover cluster? if yes, where will that new drive be stored?
I saw the post Accessing an Azure Storage Account File Share from an ASP.NET Application on Stack Overflow, but that requires code changes in all the ETL packages. Is that is the only way?