-
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
-
One day This too shall pass
This is my recently favorite poem – from one of my favorite authors. The original version is in Chinese, a simple, but eloquent, poem. I translated it and tried to make it good. Well maybe not a perfect English version, and please forgive it lacks polish and talent. I just want to share my thoughts… Continue reading
-
Encrypting files in C#.NET using the Advanced Encryption Standard (AES)
Originally posted on Ira Lukhezo's blog: Cryptography One of the biggest challenges when dealing with the security and encryption for a system, is the determination of the correct ciphering paradigm. In .NET, there is a copious amount of libraries available for use in the System.Cryptography namespace. A significant amount of these libraries have been deprecated,… Continue reading
Vision Binary 