The SSIS expression language is a powerful tool for a developer that gives you one method of making a package dynamic. When writing an expression there are a few things to be careful of that could potentially cause a stumbling block while writing code. For example, a common reason you may write expressions is to populate a changing file name. Say you want to have a file loaded but the name of the file should change each day the SSIS package is ran to have the current date appended to the end of ...
Read More
Several months ago I blogged about why Checkpoints are a great feature in SSIS to use. It seems with every feature there are potential problems you can run into and it is no different with Checkpoints. The major problem or what some people would call a feature is when Control Flow tasks are run in parallel checkpoints act a little erratically. The obvious solution for this is to not run tasks in parallel and instead have all your tasks kick off sequentially. Here’s an example of the problem: Fir...
If you weren't able to attend tuesday for SQL Lunch you can watch the recording now mosted on the website. This session was on Data Driven Subscription. We had a great group of people with lots of good questions. Thanks to Patrick LeBlanc , founder of SQL Lunch, for letting me present. Patrick recently wrote a blog post that answers a question that some people had about subscription names so make sure to read that. Make sure to watch the recorded presentation and add to your calandar some of the...
Recently while at a client I was discussing the differences between Report Builder 1.0 and Report Builder 2.0. The discussion was really around will the end user actually use Report Builder and if they will should they have access to Report Builder 1.0, 2.0 or both. I explained that Report Builder 2.0 had a lot more features than 1.0 and that if the end user is tech savy enough they should go that route. So it was decided to go with Report Builder 2.0 but I explained that the Report Manager auto...