As far as...

Also, you can check out the website of CozyRoc. They have a lot of commercial SSIS components.

You can store the customerIDs in a table and loop over this table with a for each loop container.

In the for each loop, you can configure in Variable Mappings that...

You can store the file path in a variable. Use an Excel source with an Excel Connection Manager to read out the Excel file. Then use this variable in an...

Ah OK. I thought the...

Hugo Kornelis (8/24/2010)

There's not much to say about that, as COUNT(*) does not care if...

The event handler will only be fired on specific events, and even if you go with the event handler, you still have to choose between SQL or VB.NET scripting 🙂

I...

Luckily I have SSIS open 🙂

Use the ResultSet property --> Single row

With this you can set the result of a query to a variable. Configure this in the Result Set...

You can just insert the variable in the log with a simple SQL INSERT statement.

Or, you can write OnInformation events to the log and extract the numbers there.

Carlo Romagnano (8/24/2010)

One way to avoid worrying about NULLs is never to use them, always declaring columns as not allowing NULLs and designating default values for "empty" or "unknown". This...

Again, great question and great explanation.

Nice article. It summarizes a lot of pitfalls, but I would've liked a paragraph on the behaviour of NULL in COUNT(*) and COUNT(DISTINCT *).

See http://msdn.microsoft.com/en-us/library/aa258242(v=SQL.80).aspx.

It seems that there is a problem with your logging in SSIS.

How did you configure your log provider?

At first sight, I can't spot any errors either in your expression.

Are all the quotes still there, or are some of them replaced with empty strings?