I don't think you can cover 100% in this case.. there's always be something else that can screw up.

First of all bravo for this thread. Second of all WOW for that line : "If you want everyone to be just like you, then their thought is going...

Tx for the tip.

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.