Why do I get "product level is insufficient…" error when I run my SSIS package?

This is a common question at SSIS forum, so I decided to post an answer here to save myself from re-typing it again and again Symptoms: you run a package and get an error either “product level is insufficient …” or “The task … cannot run on this edition of Integration Services. It requires a higher…

20

Where is my SQL Server Integration Services package running?

By ‘where package is running’ I mean what CPU and memory resources are used, and where the SSIS needs to be installed. This simple question surprisingly often confuses users, as there are many options to store packages and many options to run it. The answer is very short – inside the application that started it. SSIS…

11

Using C# 2.0 iterators to simplify writing asynchronous code (part 2)

Previous article describes the idea of using C# 2.0 iterators to write asynchronous code, now it’s time to implement the utility class that “runs” the iterator. The utility turns out to be very light, I’m glad some readers reported they’ve already implemented their own version. Lets list requirements for the utility: The user code should…

8

Using C# 2.0 iterators to simplify writing asynchronous code

A neat idea how C# 2.0 iterators can simplify the task of writing code that uses .NET async pattern. I’ve recently attended Jeffrey Richter’s class dedicated to effective threading techniques, and that made me think about using the .NET async pattern. The typical usage of this pattern is the following: you start one or more asynchronous…

5