Have you looked at PatIndex?

How many records are in each table? Are there any duplicates?

Thanks, Jeff. I was too hasty in my reply. Which is...

Using ASCII to grab the value of the letter, the sum of the 4 character code should be the same. The problem will be if these values can have variable...

Is this what you are looking for?

Select t1.vendorid,t1.vac1 from table1

Except

Select t2.vendorid,t2.vac2 from table2

Yes

I found this tutorial to help get me started:SSAS Tutorial

As far as books go, most actual people have commented that the Wrox series are good.

Hope this limited information helps.

Without knowing more, I'm afraid that my answer may seem a little vague.

Perhaps you could use multiple SSRS reports. I used an "initial" page to have the user click on...

Yes, that's exactly what I do with multiple tables. SSIS makes this very easy to see each step and troubleshoot if there is a problem.

One other really nice thing is...

I do something similar.

I don't use the steps in the job to move the data, I execute a SSIS package from the job's first step. Is this a possibility?

I haven't tried this, but a quick glance seems to show that you could set the "Disable" property of the Dataflow based on the value of a variable (like your...

Worst advice ever: "It can't be done."

It may not be pretty when I got done with it, but I can't think of one thing that someone said that about...

I had to do something very similar this week, this link helped out immensely.

I had to do something very similar this week, this link helped out immensely.

I will assume that the user is using the 'TAB' key to move between fields entering parameters. The 'TAB' key, if pressed while to focus is on the last parameter,...