insertion into SQL Server table
Posted: Fri Oct 17, 2008 6:47 am
Hi,
I am inserting records into SQL server table using ODBC stage.All the records from the source getting inserted even though if there is some data problem with source.
Eq :If the source column value length exceeds the target column length ,some char from source valuegetting truncated and loaded into the table.
Is there any option not to insert record if there is any datatype or length mismatch occurs in the source.
I am inserting records into SQL server table using ODBC stage.All the records from the source getting inserted even though if there is some data problem with source.
Eq :If the source column value length exceeds the target column length ,some char from source valuegetting truncated and loaded into the table.
Is there any option not to insert record if there is any datatype or length mismatch occurs in the source.