[statistics] connecting to socket on port 3802 [statistics] connected Exception in component tMSSqlInput_1 (quickcheck) java.sql.SQLException: Value 2.000- cannot be converted to REAL.
Could you please share the screenshot of the tMSSQLInput component's schema? I am interested in the datatype you have added for this column in the schema.
You must CAST from Int to String into your query by yourself.
Example:
SELECT CAST(yourIntColumn AS VARCHAR) from yourTable
Edit: you must CAST the numeric fields as soon as you want them into a String field
Tip: to get the table schema without having to enter a complete SELECT, enter the query as "SELECT * FROM yourTable" then click the "Guess schema" to get the schema of the table and finally, click the "Guess query" to generate the corresponding SELECT statement (this suppose your SQL Server connection doesn't use context or global variables which are setted at runtime - in this case, use a dedicated component for design with the connection element hard coded and copy/past both resulting schema and query into the component included into your job)
You seems to be changing at wrong area. @TRF has advised you to convert the integer columns to String within select statement and then onlyasking you to allocate to a STring data type in the schema mentioned in the tMSSQLInput component.
If you have a integer data type in underlying database, you have two options.
a) convert them to string in SQL statement itself and pass it to string variables in the schema mentioned in tMSSQLInput component
or
b) allocate the column as integer datatype itself in both select statement and schema. If needed, convert to other data types later in your flow.
