TDS || "Invalid file format" or "BCP Utility error" while importing TEXT / Conso file
If you encounter the "Invalid file format" or "BCP Utility error" while importing .txt or .tds files, follow these comprehensive steps to resolve the issue:
Set the Default Export Utility Path
- Open the software and go to the menu.
- Navigate to "Tools" → "Option Settings".
- Locate the section for setting paths for "Export Utility Path".
- Set the default path in all Export Utility Path to one of the following :
- C:\Program Files (x86)\K.D.K. Software\Spectrum\Zen TDS\Binn
- C:\Program Files\K.D.K. Software\Spectrum\Zen TDS\Binn
- For each path, ensure you:
- Click on the Default Path tab.
- Confirm the path is correctly entered.
- Click OK to save the settings.
Install the SQLNCLI → If setting the default path does not resolve the issue, proceed with the following steps to update the software:
- Navigate to the root directory of the software:
- C:\Program Files (x86)\K.D.K. Software\KDK Support
- C:\Program Files\K.D.K. Software\KDK Support
- Locate and run the "update.exe" file within the root directory.
- After launching update.exe, click on "Download Manager".
- In the Download Manager, scroll down to find "SQLNCLI for SQL Server 2008 R2".
- Once the download is complete, locate and Install the downloaded SQLNCLI file according to the system.
Reattempt File Import → After performing the above steps, attempt to import the .txt or .tds file again. This process should resolve the "Invalid file format" or "BCP Utility error".