SQLServerCentral / Integration Services / Data Warehousing / What is the best way to create a “flat file connection” to a password protected folder? / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 22:44:32 GMT20What is the best way to create a “flat file connection” to a password protected folder?http://www.sqlservercentral.com/Forums/Topic1367023-364-1.aspxWe 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?Tue, 02 Oct 2012 07:21:41 GMTChris Schmidt