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

[TRF]

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

[Anonymous]

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

[manodwhb]

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

[Anonymous]

Hello @manodwhb ,

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

Regards,

Subhadeep

[manodwhb]

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

[Anonymous]

@manodwhb,

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

Regards,

Subhadeep

[manodwhb]

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

[Anonymous]

Hi @manodwhb 

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

Though, I'm getting the error.

Regards

Subhadeep

[manodwhb]

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