I have Enterprise manager open and a query successfully returns a single row of data based on the lookup. It seems that the package is running in some other context.

The script is just pulling out 4 columns for me, and then I have a lookup task to find the key. I'll give this a try right away. As soon...