No any table column shows up during SSIS FussyLookup

#1

Hi folks,
I have one developing SSIS Visual Studio project as below:
for the following data flow tasks
step 1. for OLE DB source task, define the input table, and verify columns
selected
step 2. for fussyLookup task | in the reference window, define the
refernece table
step 3. for fussyLookup task | click column window, no any column appears
Please advise. Thanks.
Peter

#2

I figured out myself. After I change the 2nd part of table object name with
dbo, it works well. By the way the tables are in 2000 database serrver.
Thanks anyway.
Peter

"Peter" wrote:

Quote:

Hi folks,
I have one developing SSIS Visual Studio project as below:
for the following data flow tasks
step 1. for OLE DB source task, define the input table, and verify columns
selected
step 2. for fussyLookup task | in the reference window, define the
refernece table
step 3. for fussyLookup task | click column window, no any column appears
Please advise. Thanks.
Peter

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

No any table column shows up during SSIS FussyLookup

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

No any table column shows up during SSIS FussyLookup - 10-18-2006 , 10:35 AM

RE: No any table column shows up during SSIS FussyLookup - 10-18-2006 , 12:27 PM