MySql To MS SQL - Cannot insert null values into column

[Anonymous]

Hello All,

I am newbie to talend and trying to explore talend in different ways.

First thing that i have tried is transforming data from MySql to MS SQL server.

I was able to create connection and the connection was successful for both MySql and MS Sql Servers.

The flow is looks like as below image.

MySql Connection:- 

MS SQL server Connection:-

Both Connections are successful .

i did used tMap to map columns between these to.

MySql connection DB Input configurations:

And the schema of table looks like this.

tMap Configuration and mapping:-

MS Sql Server Output Configuration:-

Schema of MS SQL Server Table:-

But when i try to run this job,

it giving me error as null values cant be inserted into the table as below image.

Can anyone please guide me where i am going wrong.

Thanks in advance.

Mohan V.

[manodwhb]

@Moe ,can you check that in mysql side is that empid having null values? if yes you need to restrict in tmap ,by activating filter like row1.empid != null .

you can verify that empid is coming as null from my sql to write to file or tlogrow.

[Anonymous]

@manodwhb  thanks for the quick reply.

I am not sure where i have to write this filter expression in tmap.

so i jus tried this as above image.

but it giving the error as "Exception in thread "main" java.lang.Error: Unresolved compilation problem: "

Can you please guide me where exactly i have to write this expression and how

[manodwhb]

@Moe ,what is the data type of empid?

[Anonymous]

its varchar(8)

[manodwhb · Accepted solution]

@Moe , I am attaching the sample code,pleas find.

Tests.zip