How to give "Bulk File Path" attribute value in BulkExe components

One Star

How to give "Bulk File Path" attribute value in BulkExe components

I am using "tSalesforceOutputBulkExec" component for bulk record upload.
My MSSQL server is on different machine like(175.19.8.109) and i have installed Talend on my local machine and creating job to upload data from MSSQL to salesforce on my local machine.
Everything is fine but i have stuck on "Bulk File Path" attribute of this "tSalesforceOutputBulkExec" component. As i mentioned above my MSSQL server is on different machine and i am developing job on my local machine so i am not getting any way to give value to this "Bulk File Path" attribute.
If i give local machine file path to this attribute it throws exception like " Not able to open the File". I know i should give the machine path where this database is installed but i am getting any clue how to give Database machine (175.19.8.109) path in this attribute?
>> What if i am not sure about database machine IP? Can i give some generic path ... independent to machine ? If yes then please let me know the way?
Thanks in advance
Highlighted
Seven Stars

Re: How to give "Bulk File Path" attribute value in BulkExe components

The "bulk file path" must be the location from the point of view of the target database (Salesforce). So if you have extracted the data from SQL Server to a file on your local machine, you should just be able to reference it as e.g. "C:/MyDataFolder/MyFile.dat".
If the file is on a server, then you can reference it as e.g. "//175.19.8.109/MyDataFolder/MyFile.dat" or "//MyServerName/MyDataFolder/MyFile.dat" or, using a mapped drive, "S:/MyDataFolder/MyFile.dat".

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download