Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to update a MSSQL TAble from a csv file. My job prepare the file and then update the table using tDBOutputBulkExec because there is a lot of records.
My issue is that I have the message
Cannot bulk load because the file "D:/Run/Talend/Siebel/Data/REC/TMP/Orion/UpdAsset_ALIM_ODS_2100_APPAREIL_ORION.csv" could not be opened. Operating system error code 3(Le chemin d’accès spécifié est introuvable.)
Actually, I'm not sure I using well the talend component, I can't find example.
I read my csv file, then I'm looking for some datas in other tables and then I use tDBOutputBulk (to generate a file) and tDBOutputBulkExec to tu update the table from the file.
Can you help me to solve my problem
Thanks
Sincerelly
Bertrand
Hello @b gou
There are 3 components for bulk loading:
So, since you already configured tDBOutputBulk, I suggest you replace tDBOutputBulkExec by tDBBulkExec.
Also, instead of connecting those components using a "row" connection, replace row4 by a OnComponentOK Trigger. This will guarantee that tDBBulkExec is executed only after the file is completely written.
Thank you @Anselmo Peixoto for your help