Post reply

SSIS 2008 Lookup JOIN connector lines in the editor (visually) missing

  • June 5, 2009 at 5:25 am

    #138373

    Hello,

    It happens all the time that in the Lkp Trans Editor you cannot see any lines to connect between the JOINed columns. If you try to drag the right column on top of it's lookup match, an error arises 'Cannot map the input...to the lookup column... datatypes do not match'. This is not true though and the package seems to function anyway (and no yellow exclamation mark on top of the transformation in the package view). Sometimes you get the connector back if you recreate the lkp trans but you might have 10 in a package.... Very annoying. Any suggestions?

    Regards, Ville

  • June 5, 2009 at 8:03 am

    #1005285

    I had the same kind of problem. If we try to connect from other transformation to the lookup transformation directly it gives data type mismatch error. So i stored that result to a destination and then in another data flow i took that as a source and connected to lookup transformation, it worked did not give any error.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply