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

[ROpp1680418792]

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

[Anonymous]

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.

• 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

[Priyanka8]

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