Pieter Wolthoorn Posted April 4, 2019 Share Posted April 4, 2019 I have a SQL server database running on a Windows server and Tibco Data Virtualization (TDV) on a Linux server. The path to the BCP utility on the Windows server is D:Program FilesMicrosoft SQL ServerClient SDKODBC110ToolsBinnbcp.exe When I use this path in the configuration parameter "Microsoft BCP utility path" and set the configuration parameter "Enable Bulk Data Loading" to TRUEI get the following error when running an INSERT statement from TDV on the SQL server datasource: A system exception has occurred. at AnonymousProcedure (line 92) caused by: BCP Utility Path "D:Program FilesMicrosoft SQL ServerClient SDKODBC110ToolsBinnbcp.exe" is not configured correctly. [script-1900011] Cause: BCP Utility Path "D:Program FilesMicrosoft SQL ServerClient SDKODBC110ToolsBinnbcp.exe" is not configured correctly. [Log ID: abe5ddd2-a1f1-4d22-b23a-516adb263404] Is this because the BCP utility must be installed on the Linux server where TDV isinstalled Link to comment Share on other sites More sharing options...
Motsu Aboshi Posted May 28, 2019 Share Posted May 28, 2019 Yes. The BCP utility needs to be local to the TDV Server, not the Studio client. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now