topic Re: System Cannot Find Specified Path While MS SQL Server Bulk Insert in Talend Studio

System Cannot Find Specified Path While MS SQL Server Bulk Insert

NR1 — Fri, 15 Nov 2024 23:41:24 GMT

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,

Re: System Cannot Find Specified Path While MS SQL Server Bulk Insert

Anonymous — Tue, 28 Sep 2021 02:43:22 GMT

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

Regards

Shong

Re: System Cannot Find Specified Path While MS SQL Server Bulk Insert

NR1 — Tue, 28 Sep 2021 03:31:43 GMT

Thanks for your response.

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

Re: System Cannot Find Specified Path While MS SQL Server Bulk Insert

Anonymous — Tue, 28 Sep 2021 05:03:02 GMT

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

Re: System Cannot Find Specified Path While MS SQL Server Bulk Insert

NR1 — Wed, 29 Sep 2021 04:56:15 GMT

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,

Re: System Cannot Find Specified Path While MS SQL Server Bulk Insert

Anonymous — Wed, 29 Sep 2021 08:09:22 GMT

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.

Re: System Cannot Find Specified Path While MS SQL Server Bulk Insert

NR1 — Mon, 04 Oct 2021 04:06:51 GMT

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?