Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, there is any way to have bcp files in a different server than the server where the sql server is?
Maybe
to keep the BCP files in the app server and have a program that uploads them to
SQL Server, Talend does not support it? To upload BCP files from the app server?
In the component description says:
Note: This file can be on the same machine as the database
server resides or on another machine. If the file is on the same machine as
the database server resides, fill in the path to the file in the form prompted
in the field; if the file is on another machine, fill in the universal naming
convention (UNC) name (that is, \\{Servername}\{Sharename}\{Path}\{Filename}) of the file in this
field. In the second case, you need to have the permission to write the file.
See Bulk importing to SQL
Server from a remote data file for related information.
Thanks
in advance
Hi
When running a Job that using tMSSQLBulkExec component to bulk load the data file into SQL server, the data file should exist on the machine where database server resides, if not, the Job will fail with a message that the system cannot find the path specified, especially when the Job is executed on another machine different from the database server. To solve this problem, the following ways can be considered.
Regards
Shong
Hi I am trying this , but command is not working for me. Please suggest