Hi Pedro,
I retrieved the schema from the metadata -> DB Connections only. Please find the attached select query used in the MSSqlInput.
SELECT PSP_STAGE.DB_LOOKUP_PAY_PROVIDER,
PSP_STAGE.TXN_TYPE,
PSP_STAGE.CREDIT_CARD,
PSP_STAGE.ANALYST_GROUPING
FROM PSP_STAGE
these are columns which i need to get inserted into the target, there are also other columns in the PSP_STAGE table, which are not used, whether bcoz of it, the error is occurring.
Kindly suggest.
Thanks
Siva