Viewing 15 posts - 3,946 through 3,960 (of 11,678 total)
Easy question to start the week, thanks!
January 13, 2014 at 12:13 am
Grant Fritchey (1/12/2014)
GilaMonster (1/10/2014)
BWFC (1/10/2014)
There is a philosophical question, often kicked around our office, about what happens when two people who know everything have an argument.
I'm sure I've seen that...
January 13, 2014 at 12:12 am
sharmili.net (1/10/2014)
Then what is the purpose of using OLE DB transformation as it causes performance issue when we have execute sql task.
The performance is reasonable for small data sets (just...
January 10, 2014 at 4:17 am
Whatever you want to do, watermark or just some text, add it to the report.
Then hide it if necessary.
January 10, 2014 at 3:42 am
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
January 10, 2014 at 2:34 am
sharmili.net (1/10/2014)
why should not use OLEDB cmd since its processing each row..or any other specific reason is there?
Row by row == slow (very slow for large data sets)
January 10, 2014 at 1:58 am
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.
January 10, 2014 at 1:41 am
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...
January 10, 2014 at 1:40 am
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...
January 10, 2014 at 1:28 am
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...
January 10, 2014 at 12:49 am
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?...
January 10, 2014 at 12:42 am
Can't you just take a back-up of the database and restore it under a different name?
January 10, 2014 at 12:11 am
Can you give an example of how the source data looks like and how you want it formatted?
January 10, 2014 at 12:00 am
Viewing 15 posts - 3,946 through 3,960 (of 11,678 total)