System Cannot Find Specified Path While MS SQL Server Bulk Insert

[NR1]

Hi Talend Experts,

I am facing issue "tDBBulkExec_1 cannot bulk load because the file /talend/out/bulke_test.txt could not be opened operating system error code 3(The System Cannot Find path specified)". I understand the file should be in the same database server but

My Talend and MS SQL server are hosted in different server in AWS but both are in same VPC.

I am having 200M records in a .txt file and the size around 180GB. So kindly guide me how can I perform bulk insert.

Highly appreciate your help.

Thanks,

NR

[Anonymous]

Hi

Export the job script, move the job script to the server where MS SQL Server database is installed and run it.

Regards

Shong

[NR1]

Thanks for your response.

I am new to Talend so can you give little elaborately.

[Anonymous]

You can follow this documentation to export the job script (build jobs).

[NR1]

Thanks for the document.

If i run the .bat file in the MS SQL installed server then it will look for the file in the same server right? but my file exists in Talend server. Are you suggesting to move the file to MS SQL installed server?

Thanks,

NR

[Anonymous]

The problem is, your file must be present on the database server and it does not matter where your job runs.

You could transfer the file on your database server by file shares (Windows shared folders) or simply copy the file via SFTP e.g. to the server and than start the bulk import.

[NR1]

Thanks for your response.

I am having 180GB file so if i do SFTP it would take some reasonable time.

Do we have any other approach?