We are having a column(Say SampId) of data type varchar(50)
Suppose the records are given as
1234567890121212
1234567890121213
The second record is rejected in the job for unique key.
Records are wrongly rejected for Unique key
Moderators: chulett, rschirm, roy
Varchar(50) is capable of holding the given data.
You may need to check the data is been truncated, particularly last digit during transformation.
You need to explain more of your job design and the method of load.
You may need to check the data is been truncated, particularly last digit during transformation.
You need to explain more of your job design and the method of load.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio