March 28, 2006 at 7:18 pm
I have a DTS package that is currently taking a .txt file and dumping to a sql table. The .txt file has been replaced with a .dbf file and I am unable to configure the package to accept the .dbf file. None of the .dbf selections in the .txt file input appear correct (or don't work). Any suggestions?
March 29, 2006 at 9:45 am
You're using a "Text File (Source)" object?
Double check the file name and properties. It should not make a difference unless there's been more changed other than the the .dbf extension.
March 30, 2006 at 9:36 am
A .dbf file is usually a dBase file, that is not a text file format. You should select either dBASE III, IV or V -or- the MS dBase-VFP Driver.
Go to Control Panel, ODBC Data Sources, and try creating a DSN that points to the .dbf file using the appropriate driver; if that works then it is truly a .dbf (not just a different extension).
March 30, 2006 at 8:26 pm
I originally tried selecting dbase III , IV, or the MS dbase-vfp driver and none would allow me to select my .dbf file. The browse to file option would only allow me to surf to a top level folder, but not select the actual file. The .dbf was created from Map Info (if that makes any difference). Can you give more details on how to create a DSN that points to the .dbf file? I know how to get there through ODBC Data sources..just don't know what to select once I get there. Thanks.
March 31, 2006 at 7:35 am
That is how dbf's work, you specify only the folder in ODBC.
That's because in the dBase world, each table and index is a separate file on the disk; the folder is considered to be "the database" (more or less).
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply