How can I specify a default value to return into the lookup field for Lookup Transformation - if the value did not found on the Reference Table
Do I have to this another way (after doing the lookup)
/Yossi D.
Default value for lookup
Hot Topic
- 2005 SQL EXPRESS DATABASE BACKUP
- "sa" account and domain level rights
- Prediction with many attribute states
- Adding vertical space between rows
- Using Blobs in database
- SQLMobile install help
- Database is read-only.
- Cannot Reference and SUM fields from Table Group in Footer Expression!
- Why is there no warning if an input to an Aggregate component is not sorted
- MS SQL Server 2000 Enterprise Edition installation error
SQL Server
- SQL Server 2000 Interactive Conflict Resolution
- How to get the list of table names in a SQL2005 database
- run a dos command?
- June CTP
- Licensing for a web server
- DTS & SQL Server Management Studio Express
- User Instances in SQL Express -- Need Code Samples
- Persist Progress tab?
- Detect whether runtime or executiontime in custom component
- instawdb.sql runtime errors
Default value for lookup
sroche
Or
Set the error option to ignore, so your rows that failed to return a value just flow down the main output with null values. You can then use a Derived Column to test for NULL and assign the default value.