Error: Failed to convert column value

[Rea_Antony]

Hi,

Does someone know the meaning of this error?

Failed to convert column value from DataStage type to OLE DB type.

In my job, I was populating a varchar (2) column. I had hard coded "N" in the transformer. My job had run fine in the test environment. However, it has aborted with this error in the production environment and I'm unable to figure out what went wrong.

Please help.

[chulett]

Database? Stage? Generated or user-defined sql?

[Rea_Antony]

Database: MS SQL Server 2000
The target stage was a bulk loader. The source is an ODBC with a user defined sql. However, I am not fetching this column from the source. I had hard coded it in the transformer.

As per the logs, the error was thrown in the transformer.

[chulett]

Errors are always thrown by the transformers as they are the active stages in Server jobs. What 'DataStage type' and database type is this "not fetched from source" column?

[Rea_Antony]

but nothing is being fetched from the source... the value which has to be populated into the target was hardcoded in the transformer it self..

In this case, i had a target column of data type varchar. So i put in "N" in the transformer target defn.

[chulett]

but nothing is being fetched from the source

Yes, I know, you said that already. You didn't answer the question - you've got a Varchar in the job *and* the database for this field and it "failed to convert" it? That doesn't make a lot of sense.

[Rea_Antony]

sorry unable to read the content as im not a premium user

[ray.wurlod]

Sorry. Become one. It's not expensive, at less than 30c (Rs12) per day and is what helps to keep DSXchange alive.