Easy question to start the week, thanks!

Grant Fritchey (1/12/2014)

GilaMonster (1/10/2014)

I'm sure I've seen that...

The performance is reasonable for small data sets (just...

Whatever you want to do, watermark or just some text, add it to the report.

Then hide it if necessary.

What part are you struggling with?

Please do not crosspost. It wastes peoples time and fragments replies.

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1529663-150-1.aspx

Row by row == slow (very slow for large data sets)

Do not use the OLE DB Command Transformation.

Write the change rows to a staging table and then use an Execute SQL Task to issue an UPDATE statement.

This is not easy to do.

How are users accessing the reports?

You can build your own asp.net pages which display the reports and then you can do what you want, but...

You can put a picture in the report, make it the same size of report and fade it out.

Use an expression on the visibility property to hide it according to...

Checkpoints do not work inside data flows.

If the data flow fails, the insert transaction on the database should fail and all inserted rows should be rolled back. This behaviour depends...

The name timestamp is very badly chosen. It is a binary number, not an actual date.

Given the issues with timestamp, wouldn't it be easier to just use an IDENTITY column?...

Can't you just take a back-up of the database and restore it under a different name?

Can you give an example of how the source data looks like and how you want it formatted?

Thanks for the question.