What is the best way to create a “flat file connection” to a password protected folder?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » What is the best way to create a “flat file...

What is the best way to create a “flat file connection” to a password protected folder?

Rate Topic

Display Mode

Topic Options

Author

Message

Chris Schmidt

Posted Tuesday, October 02, 2012 7:21 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, April 25, 2013 12:26 PM
Points: 19, Visits: 110

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 »

Permissions