Invalid character value

[synsog]

This is know error to dsxchange, today I got this error. This is not the first time I am running the job, it ran almost from a year back everyday.

APT_CombinedOperatorController,0: [IBM (DataDirect OEM)][ODBC SQL Server Wire Protocol driver]Invalid character value. Error in parameter 7.

Recently, the table is dropped and recreated. There is no diff in the DDL. and also DSN as well. But I used user-defined SQL. In that.. i converted a column from Datetime2(7) into Varchar(27). Because of this it throws the above error.

I resolved by adding the null handling part.

Thanks, Sripathy.