Home > SSIS > ADO .Net Source Floating issue

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[53] 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….

Thanks
Ayyappan

Advertisements
Categories: SSIS Tags: , ,
  1. January 7, 2011 at 8:44 am

    >You can even use an Orcale provider to get the data from oracle data base within a script task. If you have experience with .Net and especially ADO.NET API programing. I think it is more per formanthttp://www.oracle.com/technetwork/topics/dotnet/index-085163.htmlYour topic could be subject of developing a custom task specialized on routing data from oracle to sql server and vice versa..

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: