Well, I did the best I could.

I 'liked' the book on Amazon, gave it 5 stars and wrote a small...

Why don't you try it out and see what happens?

The BDD component will help you to create multiple streams. Just deselect "table lock" in the OLE DB Destination with Fast...

Setting the Protection Level of Packages

It basically defines the way sensitive data is stored in the packages.

There seems to be some sort of validation error on one of the connections.

Is this the only message that you get? Can you post everything from the output window?

Do you...

Try this:

(StoreID == 4) ? 10 : ((StoreID == 10) ? 4 :StoreID)

It depends 🙂

Parallellism can give locking in your destination table if you are using a lot of indexes, but in such a large table you'd better drop the indexes before...

Chances are high Lynn is right.

Either change the SQL Server Agent account on the DEV box to a domain account, or use a proxy.

Creating SQL Server Agent Proxies

I would go...

Haven't used NULLIF before, so I learned something.

Small error: the select statement selects 4 columns, the answers have only 3.

It seems that there's something wrong with your design.

You say subcategory can be part of multiple categories.

However, in your product table you have a FK to subcategory and a FK...

Strange answer by a MS employee:

Whether to support this kind of feature depends on your client display tool, PivotTable support this kind of feature, but Excel workbook does not have...

Got it wrong for all the reasons mentioned above.

Better luck tomorrow 🙂

That doesn't answer my question.

You have a connection manager pointing to the SQL Server database where...

If you put some effort in it, you can find tons of information on the...

Hugo, thanks for the very lengthy and detailed explanation. I already figured out how it worked, but I found the original explanation "there isn't a WHERE clause" a bit lacking....

My guess is that you have duplicate rows in your source.

The first row inserts fine but at the second row you get the unique key violation error.

When you run the...