lankapala
asked on
SSIS Lookup Query
Hi Expert,
SSIS using Lookup Table , i need matched with Target table
(See attached screenshot)
01.Invoice Number
02.Invoice Sequence
03. Invoice Line
04. Order Number
05. Order Line
06. Order Realse Number
07. SiteID
Then if not matched records fields ,then need to add to Target table (INSERT all the above 7 unmatched feilds Records)
Can some let me know , looking at screenshot it's correct way to matched.
I have used Cached -Partial
SSIS using Lookup Table , i need matched with Target table
(See attached screenshot)
01.Invoice Number
02.Invoice Sequence
03. Invoice Line
04. Order Number
05. Order Line
06. Order Realse Number
07. SiteID
Then if not matched records fields ,then need to add to Target table (INSERT all the above 7 unmatched feilds Records)
Can some let me know , looking at screenshot it's correct way to matched.
I have used Cached -Partial
Thanks Raj, But When i'm using not Matched ,sometimes i found Matched also trying to transfer, then Package is going to failed.
someone is said better to use MERGE function rather than Lookup, any idea about this
someone is said better to use MERGE function rather than Lookup, any idea about this
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
Yes, matching looks good.
Just get the No Match output and insert it into your Target table.