Blog

Home - Page 7

Unexpected SSIS Precedence Constraints Behaviour

In one of my projects, I had two simultaneous sequence containers. One is executed always, and one only rarely. So I decided to control the Task Flow with a package parameter. As soon as there was task I needed to do once all paths were completed, I ran into SSIS behaviour that was (to me) unexpected.

Read More

SSRS non-ugly #3: Chart styles

This is the third post in a new series on non-ugly SSRS reports. As I stated in the opening post: SSRS doesn’t have to be ugly This week, lots of folks are tweeting and blogging about the new SSRS 2016. Exciting stuff, looks really great! But what about when you’re still stuck with one of the RTM versions of […]

Read More

Creating non-ugly SSRS reports #2: formatting tables

This is the second post in a new series on non-ugly SSRS reports. As I stated in the opening post: SSRS doesn’t have to be ugly In part 1 (the use of typography & fonts), we focused on using typography (and avoiding borders) and some colors to get rid of the Office 2003-styling SSRS has by default. One […]

Read More

Package generation with SSIS – an overview

Although you can hardly ignore BIML (with bloggers like Cathrine Wilhelmsen and Bill Fellows sharing good stuff), there are still other options for package generation in SSIS. While enjoying a small conversation on LinkedIn about the automation options, I suddenly remembered still having a slidedeck from a presentation I gave early 2014. Please note that these are my […]

Read More

Visual Studio Eror Messages

Yes, that typo was intended. Remember when I said this? [Using Google to find a solution to] Error messages? Be sure to include the exact message – “in quotes” Recently I encountered a occasion where this helped especially well. A colleague emailed me with the question why his VS2010 install didn’t load his SSRS Preview correctly. The ‘Run’ functionality worked, but the […]

Read More