What?
A quick article on an alternative to multiple lookups in SSIS. For any SSIS developer trying to create packages that need to decode a number of values into their full name/description (eg. "M" ...
... to another, sometimes you need to manage existing multi-lookups/users in a record.
How?
So the key point to remember is that all multi-select lookup and multi-user lookup fields are held in temporary ...
... Requests, Qualifications and some others.
How?
The aim/objective is the following:
Store what was already selected in the lookups
Clear the lookups list
Restore what was originally selected ...
...
Under "Export format", specify any code lookups (eg. for CAP_STAC, we want the code and the lookup value/name and then something to display if the lookup fails: &G[STA.SRS:·|·]&ABLANK="*InvalidCode*|*InvalidCode*", ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.