Hello guys,
I would like to ask how can i take the result status of the output data which i have already write in a table in sql server.
For example lets say we have the below scenario :
We write some data in DB.INFO table and after this i would like to write a line in new table for example DB.STATISTICS with these values:
Day ReferTable Status Lines
20200505(CurrentDate) DB.INFO SUCCESS(IN WRITE) 5
How can i implemet this?
Thanks
Solved! Go to Solution.
Hi @Anastasio_Theohari ,
Here is a suggestion.
You can use the block until done tool to serialize this process. 1st you write all your data to your table and then, if succeeded, write data to DB.Statistics table.
Example attached as well.
Best,
Fernando Vizcaino