topic Re: Tdboutputbulkexe with files in a different server than the server where the SQL server DB is in Talend Studio

Tdboutputbulkexe with files in a different server than the server where the SQL server DB is

ROpp1680418792 — Fri, 15 Nov 2024 21:07:19 GMT

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

Re: Tdboutputbulkexe with files in a different server than the server where the SQL server DB is

Anonymous — Mon, 15 Jan 2024 05:07:46 GMT

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.

Before tMSSQLBulkExec, use a tFTPPut component to upload the data file to the machine where database server resides.
Create the data file in a shared location that is accessible by your database server as described in this Microsoft Doc.
Use BCP utility instead of tMSSQLBulkExec to bulk copy directly the data file to SQL Server, about BCP utility, please refer to this page. The below screenshot shows an example that generates a data file in a user-specified format and call the BCP command on a tSystem component to bulk copy the data file to SQL server.

Regards

Shong

Re: Tdboutputbulkexe with files in a different server than the server where the SQL server DB is

Priyanka8 — Wed, 07 Aug 2024 04:59:47 GMT

Hi I am trying this , but command is not working for me. Please suggest