Thank you all for helping me out! This was a huge timesaver. I ended up using Sean's code, but I tested David's and that would have worked as well.

SQLServerCentral.com...

Thanks,...

We did this very same "string distance" matching algorithms 3-4 years ago at a place I worked. It works great for small datasets, but SSIS fuzzy matching is much faster...

I finally was able to resolve this issue.

Turns out that somehow 2 variables of the same name got created. When I looked at the variables though, it did not...

John Rowan (5/1/2009)

---

I have a package that does the exact same thing. Here's how it is set up:

1. Package does some import stuff.

2. Execute SQL Task checks table row...

No problem.

Basically, I want to check if data is available in a table by doing "SELECT COUNT(ID) FROM Table_A". I want to pass the value of the count to...

Same results. The excutes SQL task runs successfully, but never changes the variable value.

I should have mentioned in my original post, I have my precedant contraint set as such:

Evaluation operation = Expression and Constraint

Value = Success

Expression = @[User::CheckData] > 0

Logical AND

Thanks!

I thought the solution might be something similar to that. I had the first OR statement in my test code, but not the second OR statement. I ran the code...

Thanks Jack.

I am getting an error when I inject that code into the expression.

=(Fields!AvgDailyTalkTime.Value\60*60).ToString("0#") & ":" & ((Fields!AvgDailyTalkTime.Value \ 60) - 60).ToString("0#") & ":" & (Fields!AvgDailyTalkTime.Value mod 60).ToString("0#")

The...

I have this problem as well. I was studying for 2-3 months on SQL Server 2005 and then my company moved production environments to SQL Server 2008. Now I hear...

Thanks everyone. Jack's solution looks like it is going to work for me.

I don't have the ideal situation in that the field contains the full name of the employee...

Looks like this is going to work out perfectly. On first pass through it looks like it caught all of the ID's and put them on seperate lines like I...

Excellent, worked exactly as I originally needed.

Curious, I've never heard of spt_Values until now. What is it typically used for?

Thanks Jeff, you've helped me out a few times in the past couple of weeks. I really appreciate it.

I like the idea of not using 12 IF's, but it...