You are welcome.

There are a few ForEach Loop blogs here.

http://sqljunkies.com/WebLog/knight_reign/archive/2005/03/25/9588.aspx

K

Use exception handling and use a messagebox to show the exception with the stack etc. It will show you exactly where the callsite was that caused the error or at...

By the way, for those that are interested, there is a new topic on MSDN that documents the trick for how to get an error description out of an error...

"less than worthless"

Thanks for that resounding endorsement David!

K

That's right and the only packages that the server enumerates are in the special folder on the server, specified in the MsDtsSrvr.ini.xml file.

K

You've always been so optimistc though David. Why give up hope now?

Kidding aside, unfortunately, you haven't really posted enough information to diagnose the problem.

The errorCode...

BI studio shouldn't have these options, it's Management Studio, yes?

Is Integrations Services installed on all machines?

I've never seen a connect to server option in Management Studio.

In BIDS, the connect to...

Place a rowcount transform between the error output and the destination adapter. Place a sendmail task in the workflow after the Dataflow task. Place an expression on the precedence constraint...

Or, you can just use the calc.exe program that ships with the OS. Make sure you select View | Scientific. It will do the conversions to binary, hex, decimal and...

Looking at the error messages in MSDN I found the following.

You can find them all here. 

http://msdn2.microsoft.com/en-us/library/ms345164.aspx

Being...

Well, you do have the partial cache feature that sounds like a better approach than fully caching in your circumstance, since it only caches each row on looking it up....

I understand better now.

I think you have some valid points.

Saying the lookup is useless, or whatever wording you use is inaccurate.

Saying that it doesn't meet every need in every situation...

You should use the results of a query to narrow down the lookup reference set.

Select the "Use results of an SQL query:" to only bring in the 1000 records in...