SSIS Design

• Mike Levan

  SSChampion

  Points: 14201

  More actions

  May 20, 2008 at 12:34 pm

  #191112

  I have 2 schemas X and Y.

  X has Employee Table in which I have10 fields

  Y has OldEmployee table which has EmpNo

  X has 5 fields which I need to lookup in table A.SiteLink,A.EmpLink,A.PayLink.

  If the field matches its fine but if it doesnt has the data then it shud return NULL.

  All this will be in single data flow task. what is the best i can proceed with.

  thanks

• KenpoDBA

  SSCrazy Eights

  Points: 9811

  More actions

  May 21, 2008 at 7:59 am

  #818579

  Well, The simplest answer is always the best... so why don't you just do a join in your source connection?

  Barring that, a lookup transform should get you there too.

  Watch my free SQL Server Tutorials at:
  http://MidnightDBA.com
  Blog Author of:
  DBA Rant – http://www.MidnightDBA.com/DBARant

  Minion Maintenance is FREE: