The bcp utility (Bcp.exe) is a command-line tool that uses the Bulk Copy Program (BCP) API. The bcp utility performs the following tasks: Bulk exports data from a SQL Server table into a data file. Bulk imports data from a data file into a SQL Server table. liteblue login
The BulkExec use it on the remote SQL Server so the path to the file must be from the point of view of that remote server i.e. if you use "C:/Temp/file.csv", the job will try to find the file on the C: drive of the SQL Server. Liteblue.USPS.Gov
Could you share your experience about this question if you have idea. Bulk exports data from a SQL Server table into a data file. Bulk imports data from a data file into a SQL Server table. liteblue usps gov
If you are using Enterprise Version of Talend Example, Data Fabric, in that case, you will have an Execution Server option in Run Tab. Where in you can set a Remote server IP (instead of LocalHost) which can be accessed by both your SQL Server (SSMS) as well as Talend.
But if you are using Open Studio version then, in that case, you will have to install Talend and SQL on the same machine. Make sure permissions necessary for Bulk Operations is enabled in SSMS for your Service Account / Windows Authentication, then even with LocalHost pointing to any local drive(C drive) file. Bulk insert operation in Talend should work.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema