Write in new table the output result

[Anastasio_Theohari]

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

[fmvizcaino · Accepted 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