Truncate Table then Insert

[thomas_2583]

Hi,

I have the following process flow of which I need to tweak slightly if possible.

TDBInput ---> TMap ---> TDBOuput (Update and Insert).

Is there anyway that I can include somewhere within this job design to clear down (truncate) the table that is used within the

TDBOuput , and then insert the same table with the latest data?

[gjeremy1617088143 · Accepted solution]

Hi @Steven Littlewood​ , on the tDBOutput you have a field named action on table, you can select truncate table in.

It will truncate the table before insert.

[thomas_2583]

Hi @guenneguez jeremy​ That's brilliant, thank you for your help!

[Jwoodberry]

Does anyone know what i'm doing wrong here, I have a webpage that gets currency data from a remote source, I get the data and insert it into sql database via a stored procedure. If i put truncate in front of the insert statement, it truncates the table and inserts the last record. If i remove the truncate, it inserts all the records. MyAccountAccess Credit Card