I tried the same thing myself. I ran into no issues. The only difference was I did not build the SQL string I created a static string.

I suggest adding a MsgBox statement for debugging to determine the point the package is dying at exactly.

Also add "Option Explicit" at the begining of the ActiveX script to make sure there are no typos in your variablesas the root cause. Looked like cleanup had a typo but that would not affect you.

If you get past the point of building the string then MsgBox you SQL String and make sure there are no errors.

Comment out the section around Lookups only and slowly add those pieces to be sure it is the Lookup collection itself.