ADO .Net Source Floating issue
I would like to discuss one of my migration project experience using SQL Server 2008 R2 SSIS.
The spot light issue is, i would like to make my article very simple. I have oracle as data source with few huge tables that is column wise and row wise as well.
I used SSMA tool to migrate oracle schema to sql server. it has created the data type mapping for number to float or float in SQL server.
but, in my case data in Oracle number column has more the 40 scale length. in case of SQL Server float keep very less scale length approximately 15 scale length.
Now, I come to the matter. when I design a ssis package to transfer data from oracle to sql server, I preferred to use ado. net source and destination task. But ado.net source refused to handle the number data with more scale.
So, I was trying to find out the alternative solution to fix this issue. Immediately, my programming brain gave me one clue to change ado.net source to ole db source. Luckily, it works fine……
I said thanks to ???…. 🙂 but the solution was compromising not resolved. Because, while data transfer, it automatically truncated the float scale values after the maximum limit.
Anyway, I was able to convince the customer and completed the project 🙂
This is my experience with ado.net source task in ssis.
I will post another article with an interesting issue with solution….