-
SSRS report Blank pages–updated
1.Blank page between each data page. Go to report properties check the page size and margins. Here is an example that how blank pages occurs every time between two pages which content data. In report properties the page width is 8.5 in, however in design panel, the real body width already exceeds the limit. 1-1… Continue reading
-
SSRS report “Loading” forever on Browser–solve the compatibility issue
Today my report business owner shot me an email said she can’t see my report. it displaying “Loading” for 20 minutes. I did a quick check at my side, everything looks fine for me. So I let my other coworkers access the report URL, try to see if they can see the report at their… Continue reading
-
The Big Red Book of Modern Chinese Literature (Book acquired, 8.07.2015)
Source: The Big Red Book of Modern Chinese Literature (Book acquired, 8.07.2015) Continue reading
-
How to keep your SSIS package ‘DRY’
Originally posted on The Proud Salopian: So, you all know the deal… When it comes to coding there is one rule that all half decent programmers aspire to; Nope, it’s not ‘Never toss a dwarf’ which whilst being reasonably good advice is probably not quite relevant to normal weekly challenges at the coal face of… Continue reading
-
Add missing dimension members during fact load
Originally posted on sqlbidan: This is a variation of a pattern I saw in SQL Server Integration Services Problem Design Solution by Erik Veerman, Jessica Moss, Brian Knight, and Jay Hackney. I would highly recommend this book. I found at least 4 chapters in the book that were each worth the price of the book. … Continue reading
-
SSIS – Non-blocking, Semi-blocking and Fully-blocking components
Originally posted on korasql: Synchronous vs Asynchronous Synchronous components The output of an synchronous component uses the same buffer as the input. Reusing of the input buffer is possible because the output of an synchronous component always contain exactly the same number of records as the input. Number of records IN == Number of records… Continue reading
-
Resolution of SSIS Error: Error 0x80070005. Failed to create an instance of empty child package
Originally posted on The Crawling Post: It has been some time I have updated my blog. So I thought of writing one and nothing better than the area in which you work. Sometime back I got this error “Error 0x80070005. Failed to create an instance of empty child package” in a new machine and broke… Continue reading
-
Illustration for Edgar Allan Poe’s story “The Man of the Crowd” — Fritz Eichenberg
Originally posted on Biblioklept: Wonderful Fritz Eichenberg illustration to one of my favorite Poe stories, “The Man of the Crowd,”. Via a gorgeous gallery at Full Table. Continue reading
-
Medieval Letter-People
Originally posted on medievalbooks: The human body is one of the most common objects encountered in art, whether in paintings, sculptures or other objects. Things have not changed much since medieval times, when artists loved to fill their work with human figures – commonly saints or individuals affiliated with biblical stories. Among the great diversity of depictions, there… Continue reading
-
Environment Variables in SSIS Packages and Configuration Tables
Originally posted on MikeDavisSQL: Configuration tables are a best practice in just about any SSIS environment. They make it easy to update multiple packages from a single change. But one of the issues with configuration tables is the location of the server is different on each server. You may have a Server name of Dev… Continue reading
Vision Binary 