all groups > sql server dts > october 2007 >
You're in the

sql server dts

group:

Available Input columns on Lookup not available


Available Input columns on Lookup not available dba
10/3/2007 4:19:06 PM
sql server dts:
When I tried to use the Lookup the checkboxes are not displayed on the
Available Inputs they are on Available Lookups, I thought it was a
datatype missmatch so I pumped it through a data conversion before
hand so both sides are varchar(25) trying to do a lookup on State.
Still same problem, anybody seen this before?
Re: Available Input columns on Lookup not available Kent Tegels
10/3/2007 11:25:01 PM
Hello dba,

have you linked any of the columns yet?

Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/

Re: Available Input columns on Lookup not available dba
10/4/2007 7:59:34 AM
[quoted text, click to view]

No I haven't I tried deleting and recreating the Lookup task in
serveral places including directory from the OLE DB connection to the
lookup. Still same problem no available check boxes in Input columns
and OK box is always grayed out because it says I have to select one.

Regards,
Bryan
AddThis Social Bookmark Button