none
Lookup Transformation Issue RRS feed

  • Question

  • I am a beginner in SSIS and is stucked with a small issue.

    I have a reference data as Location with holds info as below:-

    OU-PYN

    OU=HHO

    OU=PBJ

    I need to search this value in another table a populate corresponding values in other column as foreign key.

    Problem is other fact table holds values as:-

    CN=HSHHKCRWDC02,OU=Server,OU=HHO,DC=HSHTPH,DC=Global
    CN=PNYNexPose,OU=Windows Update,OU=Workstation,OU=PNY,DC=HSHTPH,DC=Global
    CN=HHOITVMTESTPC03,OU=ITC,OU=IT,OU=Workstation,OU=HHO,DC=HSHTPH,DC=Global
    CN=PBJHK6888,OU=PC Non-USB,OU=Workstation,OU=PBJ,DC=HSHTPH,DC=Global

    I need to search location values in above values and then populate the values in column.

    Kindly advise

    Tuesday, November 27, 2018 7:30 AM

Answers