Using tablename and columnname in lukup from OLEDB SRC

• sql_learner29

  SSCrazy Eights

  Points: 9107

  More actions

  August 26, 2008 at 6:51 pm

  #127243

  I want to use the table name and the lookup Column name in my flow..Can I get them from som where in the dataflow variablles..

  data looks like dis:

  ---------------------------

  DBNAME TABLE NAME COLNAME CoRRESATTRB

  ---------------------------

  AB X ICODE GCODE

  AB Y PCODE G1CODE

  AB Z RCPDE G2CODE

  ---------------------------

  now in my OLE DB SRC i selected the DBname and the Table name...

  but later on in the flow I want to reference the table name tht I selected..

  How can I get tht in the flow afterwards...(any way)

  Actually the problem is like this:

  In my source table I select only one table name

  Src_dbname

  SRc_Tabname

  Src_Colname...

  Now when I do lookup on an another table..I need to pass values for those all coming from Source so that I can get corresponding lukup value for tht table that column.

  I need to get values of Src selection in the flow...and neeed to use them in lukup tx...

  Any help on this..

  Thanks in Adv

  [font="Comic Sans MS"]
  ---------------------------------------------------

  Thanks [/font]

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  August 27, 2008 at 1:03 am

  #863523

  If you trying to modify the lookup at runtime, you cannot. Query for the lookup is static.

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!