Maybe I've missed something but shouldn't the lookup table have all possible values. I can imagine having a states table with only 42 states in it because they...

Damn I got to get on book on dts... don't know nothing about that stuff (read basic stuff) .

Then I think you will benefit from reading this small article. It talks about cache miss that is caused by calling the same proc with different syntaxe. This...

How about you recount that for the last month?

How is it different from my solution???

The root of the problem is that he wants to do it in a single report formated query... He's not even sure he wants to use excel to do this.

No offense taken... not the first time it happens on this site .

Too much trouble to go to Europe to get your check...

Also is it possible that this stored proc is called from more than one place?

Because it would look like their were 2 different plans being used for this proc...

A few questions come to mind :

1 - Have you received a message explicitly telling you that the package finished or failed?

2 - How did you start the package?

3...

It's hard to tell from that error message.

What I ususally do is rerun the package by hand (I manually restart each step one by one). But when I rehit...

Sorry about that... forgot to test that response.

Glad you got it to work.

Declare @search as varchar(25)

set @search = 'id'

Select name from dbo.SysColumns where name like '%' + @search + '%'

order by case when name like @search + '%' THEN 0 ELSE 1...

Select A.CompanyID, A.ItemDescription, A.ItemReferenceNumber, A.ItemQty from dbo.YourTable inner join dbo.Numbers N on A.ItemQty <= N.PkNumber

--I use this table for many other string operations as well

CREATE TABLE [Numbers] (

[PkNumber] [int] IDENTITY...

HTH.