Posts Tagged ‘Text File’
ODBC Text File Connection
This week’s Tech Thursday will show you how to use a UNC pathname when you are writing your own query using the Microsoft Text ODBC driver. Normally using a UNC pathname is preferable to using a mapped drive letter, since mapped drives can vary from machine to machine. However once you are in the text ODBC…
[Read More]
Tech Tuesday : SmartConnect – Changing the Column Names on a Text File Destination
One feature that has been asked for by customers is the ability to specify column names when using the Export to File feature. By default, as of the latest SmartConnect 20.16.0.31, when exporting to a file is that the source file column names will be used as the output column names. This issue is potentially…
[Read More]