Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

What is the best way to create a “flat file connection” to a password protected folder? Expand / Collapse
Author
Message
Posted Tuesday, October 2, 2012 7:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, January 16, 2014 7:52 AM
Points: 22, Visits: 119
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?
Post #1367023
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse