You said it yourself: Derived, use the Derived Column component.

Using expression syntax you can check the data of any field for existence of certain conditions. If found, you...

seems to me that simply searching this site will provide many questions and answers.

I just make it a validation step in the load package, failing the package if numbers don't jive.

After I have a staging table popped, I do a "second dip" and...

I'm an A. This is the best job I have ever had and I look forward to coming in each day. I thought the feeling would pass, but...

This series comes at a great time for me as I am currently "between cubes" and in more of a refinement stage (ok, Cleanup, but also making tweaks as needed)....

also, we create Lag fields. Integers normally expressed as number of days.

Time from inception to event, time from any event to any other event. We also move things...

We have a date dimension that covers past and future (I didn't build it so don't know offhand how far we go to either extreme, but far enough for our...

oh good, it's not just me! I was unaware that industries would have templates for their DWs and would be surprised if they were shared as I know my...

I'm with you. Blame is absolutely a negative word.

"Who is responsible" is nicer but still smacks of my mother being mad about something and demanding to know "who is...

Just a guess, but check your datasourceview to see that it is in fact collecting the entire table. We sometimes use a query to leave out fields we want...

I'm glad it's working for you!

can you please post what worked to solve it?

It's always nice to see the solution in the same thread with the problem so others with...

I think you will have more luck finding answers on either the SQL 2008 forum or Reporting Services forum.

I don't think that SSIS can do this but interested to see...

rather generic, I don't include a lot here. We have a custom email sp to add formatting in keeping with corp look and feel for such things, but this...

Sober,

No gripe at all. I have toiled in the sparse budget arena of non-profit and without Office/VBA, would have been hard-pressed to create the user-friendly tools I needed that...

keep poking around in the errors as I will get a timeout due to the cube trying to do something it can't (key not found, for example). You could...