We have a password protected Samba drive we need to retrieve our ETL flat files from.
Currently we are running a batch file in the ssis to map to the drives using the userid and password.
This has worked successfully in the past, however it has been failing for the last 2 weeks. I have another post with some more details about this.
But the reality is, in my opinion, is that this is just a work around in the first place. The million dollar question is:
What is the best way to create a “flat file connection” to a password protected folder?