ReportServer Forum

unsi_2

Member

Registered: 2020-06-24

table datasink record duplication

hi

we want to stored data from a query(a report) in a table datasink periodically.

the problem is that every run, data is added so it duplicates.

is there a way to get the table refreshed with new data? deleting before inserting or just inserting only new records.

kind regards

Last edited by unsi_2 (2023-06-28 06:28:41)

eduardo

Administrator

Registered: 2016-11-01

Website

Re: table datasink record duplication

Hi unsi_2,

this is currently not possible, but makes sense and should be doable (option on datasink definition to delete all records from table before adding new data). We raised ticket RS-7553 for looking into this.

Regards,
Eduardo

unsi_2

Member

Registered: 2020-06-24

Re: table datasink record duplication

thanks Eduardo

eduardo

Administrator

Registered: 2016-11-01

Website

Re: table datasink record duplication

Hi unsi_2,

the next ReportServer 4.7.0 will allow to truncate the table in table datasinks before copying the data to the table. This has already been implemented and will be available in 4.7.0.

Regards,
Eduardo

eduardo

Administrator

Registered: 2016-11-01

Website

Re: table datasink record duplication

Hi unsi_2,

pls note that 4.7 is released where this functionality is supported:

https://reportserver.net/releasenotes/RS4.7.0.html

RS-7553    New Feature    Allow to truncate table in table datasinks

Regards,
Eduardo