Error IN DRS stage

[rsomiset]

Hi folks,

I am getting an error , When i am trying to Extract sqlserver table using DRS stage...Especially for one tables rest of the tables are working fine.

Error Message:-

xyz..xyz: [DataDirect][ODBC SQL Server Driver]Numeric value out of range
xyz..xyz: SQLFetch: Error retrieving results from server.

please Help me to resolve this ...

Thanks in advance

[ray.wurlod]

What is your workaround?

Numeric value out of range usually indicates a metadata mismatch, for example you are trying to retrieve a six-digit number using a column defined as SmallInt.

[rsomiset]

Hi Ray,

Thanks for the response... I checked it and increased Length of the numeric fields of also...

Regarding the metadata mismatch I am able extract it using ODBC stage without any issue..
For odbc i have not changed anything .. wht ever the metadta i imported i am using that ... It is working fine.

When i use RDBMS stage it is giving this problem for me ..

[ray.wurlod]

How is the database type property of the Dynamic RDBMS stage set?

[rsomiset]

Database type property is set as a "MSSQLSERVER"
I am facing this problem only for one table out of 80 tables in the same schema... Rest of the tables are working are fine with DRS stage.