topic Re: Error in MS SQL Server Bulk load in Talend Studio

Error in MS SQL Server Bulk load

Anonymous — Sat, 16 Nov 2024 02:19:29 GMT

Hello Experts,

Hope you all are safe & healthy !

I'm having issues with "tDBBulkExec" component for MS SQL server DB. As a first step I'm successfully able to create the temp file using 'tDBOutputBulk' component but after this process, while I'm trying to load into target SQL server db, its throwing error :

<<<tDBBulkExec_1 Cannot bulk load because the file "C:/*****/***/*****/Desktop/out.csv" could not be opened. Operating system error code 3(The system cannot find the path specified.).>>>

Note :

- I've attached the screenshot for the job snippet.

- I conform that, the file is present in the path.

- I've tried with 'tDBOutputBulkExec' component as well. throwing the same error.

Any help for this scenario would be much appreciated.

Best Regards

Subhadeep

Re: Error in MS SQL Server Bulk load

TRF — Tue, 26 May 2020 22:01:57 GMT

tDBBulkExec is placed in order #2 of OnSubjobOk. What's going on in order #1?

Re: Error in MS SQL Server Bulk load

Anonymous — Wed, 27 May 2020 03:45:37 GMT

Hi,

In SubjobOk order 1,some audit column loading mechanism is happening.
I guess,this wont be the reason for my error.
Correct me if I'm wrong.

Regards
Subhadeep

Re: Error in MS SQL Server Bulk load

manodwhb — Wed, 27 May 2020 05:07:40 GMT

@ADee, you need to take on component ok from the tDB2outputbulk and connect to tDBBulkExec.

Re: Error in MS SQL Server Bulk load

Anonymous — Wed, 27 May 2020 07:34:48 GMT

Hello @manodwhb ,

I've tried that 'OnComponentOk' approach as well, but unfortunately same error as previous.

Regards,

Subhadeep

Re: Error in MS SQL Server Bulk load

manodwhb — Wed, 27 May 2020 07:36:32 GMT

@ADee, are you using the same file in tDBBulkExec which you are creating in tDB2outputbulk ?

Re: Error in MS SQL Server Bulk load

Anonymous — Wed, 27 May 2020 07:38:18 GMT

@manodwhb,

I confirm that, both files are same. I've crosschecked it several times.

Regards,

Subhadeep

Re: Error in MS SQL Server Bulk load

manodwhb — Wed, 27 May 2020 07:49:01 GMT

@ADee, have you verified manully that the file is created or not as part of tDBoutputBulk?

Re: Error in MS SQL Server Bulk load

Anonymous — Wed, 27 May 2020 07:51:07 GMT

Hi @manodwhb

Yes, I've verified manually. The respective file has been created in ';' delimited way.

Though, I'm getting the error.

Regards

Subhadeep

Re: Error in MS SQL Server Bulk load

manodwhb — Wed, 27 May 2020 08:05:13 GMT

@ADee , I do not think that if you are using same file it will not give error in file. can you share file name ,if you are using context variables in a file name you can print using tjava,is that file is correct or not.

Re: Error in MS SQL Server Bulk load

Anonymous — Wed, 27 May 2020 08:17:16 GMT

Hi @manodwhb

I've checked the local file location details multiple times before posting the query.I'm not using any context file loc, rather I'm hard coding the file location for testing purpose. So, no issue in file locations for both components.

I'm wondering that,

1. In 'tDBOutputBulk', the label name is 'File Name' .

2. But in component 'tDBBulk_Exec' component, the label name for file name is 'Remote Filename'

Regards

Subhadeep

Re: Error in MS SQL Server Bulk load

manodwhb — Wed, 27 May 2020 08:27:30 GMT

@ADee , i am seeing the label is Data File Name in tDBBulk_Exec ,please check screenshot.

Re: Error in MS SQL Server Bulk load

Anonymous — Wed, 27 May 2020 08:34:41 GMT

Hi @manodwhb

Thanks for the confirmation. But as our heading suggest we're using MS SQL Server.

You can crosscheck my option with changing the DB type to MS SQL Server in 'tDBBulk_Exec' component.

Thanks,

Subhadeep

Re: Error in MS SQL Server Bulk load

manodwhb — Wed, 27 May 2020 08:40:34 GMT

@ADee , check the below

Remote File Name

Name of the file to be loaded.

Warning:

This file is located on the machine specified by the URI in the Host field so it should be on the same machine as the database server.

https://help.talend.com/reader/ezRX_mq4Tbshah1ovEVfbg/rh~5Ym4vTQ7V5hAxctTKqQ

Re: Error in MS SQL Server Bulk load

manodwhb — Wed, 27 May 2020 08:48:33 GMT

@ADee ,check for tMSSqlOutputBulkExec component will fit into your requirment.

https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/GGkGgNOCYYMeqjNO_fCedg

Re: Error in MS SQL Server Bulk load

Anonymous — Wed, 27 May 2020 08:49:08 GMT

Hi @manodwhb ,

Regarding the talend documentation you just shared, So can't we test the bulk load with local files ?

(what you were wondering to be same ?)

If possible, please elaborate a bit.

Regards,

Subhadeep

Re: Error in MS SQL Server Bulk load

manodwhb — Wed, 27 May 2020 08:57:31 GMT

@ADee, if you have want to generate file and upload using using bulk component you need to use tMSSqlOutputBulkExec .

if you have file in the DB server which you want load into DB using bulk option you need to choose tMSSqlBulkExec.

Re: Error in MS SQL Server Bulk load

Anonymous — Wed, 27 May 2020 10:00:30 GMT

Hi @manodwhb

Do you mean that using tMSSqlOutputBulkExec component, I can avail the bulk load insert with the help of LOCAL file ??( Instead of Remote file in the hosted DB server)

Thanks,

Subhadeep

Re: Error in MS SQL Server Bulk load

manodwhb — Wed, 27 May 2020 10:14:36 GMT

@ADee, Yes that if use tMSSqlOutputBulkExec component alone will create a file in local and which will be uploaded that data into DB.