<div>
When Fill uses OracleDataReader.GetValues<wbr />, numeric values are converted from<br />
OracleNumber to System.Decimal which has a smaller range and the risk of<br />
overflow. &nbsp;In V1.1 there is no workaround other than to not use Fill and<br />
directly call OracleDataReader.GetOracle<wbr />Values.<br />
<br />
In .Net Framework V2.0, there is a new property on OracleDataAdapter called<br />
ReturnProviderSpecificType<wbr />s in which the adapter will create the DataColumn<br />
with OracleNumber instead of System.Decimal.<br />
<br />
you can overcome this by using the ROUND() to decrease the precision of your oracle number field in your source query.<br />
&nbsp;also take a look at this link<br />
<br />
<a href="http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/4032e2fe-9f37-47d8-9af6-35f1675e9d84/" rel="ugc nofollow">http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/4032e2fe-9f37-47d8-9af6-35f1675e9d84/</a>
</div>


When Fill uses OracleDataReader.GetValues, numeric values are converted from
OracleNumber to System.Decimal which has a smaller range and the risk of
overflow.  In V1.1 there is no workaround other than to not use Fill and
directly call OracleDataReader.GetOracleValues.

In .Net Framework V2.0, there is a new property on OracleDataAdapter called
ReturnProviderSpecificTypes in which the adapter will create the DataColumn
with OracleNumber instead of System.Decimal.

you can overcome this by using the ROUND() to decrease the precision of your oracle number field in your source query.
 also take a look at this link

http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/4032e2fe-9f37-47d8-9af6-35f1675e9d84/ [http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/4032e2fe-9f37-47d8-9af6-35f1675e9d84/]

<div>
HI &nbsp;<br />
can I use ant setting in SSMA to over come this mine is sql server migration Assistant for oracle 4.0.1402<br />
<br />

</div>


HI  
can I use ant setting in SSMA to over come this mine is sql server migration Assistant for oracle 4.0.1402



<div>
this issue was solved thatnks &nbsp;for the help
</div>


this issue was solved thatnks  for the help

<div>
<div class="content wysiwyg-content">
Hi ,<br />
<br />
I am getting the Error OCI-22053: overflow error&nbsp;while trying to transfer data from Oracle to Sql server by using &nbsp;Sql server management assistant &nbsp;<br />
This happens after 80k rows &nbsp;which is 24% of the total volume <br />
can someone help me out !!!!!!
</div>
</div>


Hi ,

I am getting the Error OCI-22053: overflow error while trying to transfer data from Oracle to Sql server by using  Sql server management assistant  
This happens after 80k rows  which is 24% of the total volume 
can someone help me out !!!!!!

Date Transfer through Sql server migration assistant

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.