ODBC connection to text file
Julie S asked 10 years ago
Hello,
About a year ago I set up a mapping using a text file as my source. Now I need to change the path and I can't figure out what I did.
I used an ODBC connection as the Data Source. Then in my connection string I connected to a text file with a UNC path.
Once connected I run a query against the file.
I can't figure out how I set this connection up to a UNC path.
Can anyone help?
About a year ago I set up a mapping using a text file as my source. Now I need to change the path and I can't figure out what I did.
I used an ODBC connection as the Data Source. Then in my connection string I connected to a text file with a UNC path.
Once connected I run a query against the file.
I can't figure out how I set this connection up to a UNC path.
Can anyone help?
Answers
Best Answer
lorren answered 10 years ago
lorren answered 10 years ago
Julie,
When you select the Text File Connection type, uncheck the "Use Current Directory" option and then click the Select Directory button.
In the Select Directory window, in the upper left hand corner, enter the UNC path and then you should be able to click OK.
Thanks
When you select the Text File Connection type, uncheck the "Use Current Directory" option and then click the Select Directory button.
In the Select Directory window, in the upper left hand corner, enter the UNC path and then you should be able to click OK.
Thanks