insertion into SQL Server table

[svga]

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.

[ArndW]

There is not a builtin method that will do this for you automatically, as string truncation and data conversion is automatic. You will need to put checks into your job to ensure that the data is correct..