Error in MS SQL Server Bulk load

[Anonymous]

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

[Anonymous]

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

[manodwhb]

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

[Anonymous]

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

[manodwhb]

@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

[manodwhb]

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

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

[Anonymous]

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

[manodwhb]

@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.

[Anonymous]

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

[manodwhb]

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