.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

datatype mapping for columns from oracle

Posted By:      Posted Date: October 18, 2010    Points: 0   Category :Sql Server

hi all,

my Data Source View connects to an Oracle database via Oracle Provider for OLE DB,

and there is a dimensional table named DIM_CITY, and one of its columns , city_id has the integer oracle type.

if i directly add this table as a table to my DSV, the datatype of city_id in DSV would be System.Int64, which i think is appropriate. if i use it from within a named query(SELECT a.*,b.province_name  FROM dim_city left join dim_province b on a.province_id=b.province_id), then the datatype of city_id is System.Int32, which causes troubles as i can NOT add relationships when city_ids in other tables are of type of System.Int64.


any suggestions will be appreciated.



Andrew Chen
Interested in BI related technologies

View Complete Post

More Related Resource Links

oracle clob datatype length more 32000

Hi Friends       i am using a microsoft enterprise library for oracle data base. we return an output value of clob datatype in oracle of character length more thant  32000.How to handle this type problems in C#.net.if the passing a varible of string ,it chara cter limit is 32000.if than 32000 ,how to handle this in enterprise library.  

Mapping custom values and columns to destination table **Newb question**



I am copying data from one source to destination SQL CE table using the data flow task. I have two extra requirements which I am not sure how to achieve.

1.)  One source column needs to be mapped to two destination columns. In the column mapping dropdown the column name disappears after mapping it to one destination column.

2) some custom values for columns need to be added, which are not present in source. For e.g. a default value for some destination columns which is not present.

Any pointers would be extremely appreciated. Thanks,

Ganesh Ranganathan
[Please mark the post as answer if it answers your question]

Error on mapping oracle varchar2 to sql server 2008 using import facility, defaults to type 129 in m



I am trying to use the import wizard to import an oracle 10g table into an sql server 2008 (10.0.2531) database, it comes up with the error 'data types of source columns were not mapped correctly to those available on the destination provider'. When I go into 'edit mappings' it shows all the varchar2 oracle columns mapping to type 129 ? all the other columns have normal mapping types. If i go through and change 129 to varchar the import will work ok.

I understand that in c:\Program files\microsoft sql server\100\dts\mappingfiles there is a series of files that map datatypes to/from different sources, there are 3 files

oracleclienttomssql , oracleclienttomssql10 , oracleclienttossis10 which have a varchar2 to nvarchar mapping

and 2 other files  oracletomssql ,  oracletomssql10 which map varchar2 to varchar and one other file, oracletossis10 which maps varchar2 to dt_str

I running the import on a server with an Oracle client installed with sql server 2008 (10.0.2531).

I am not sure which mapping file is being used ? and whichever one is being used it should provide a mapping rather than type 129 (whatever that is).

I would like to get this mapping resolved as I have many tables to import and over time the structure of the Oracle tables will change so I want to use import as the easiest optio

datatype tranformation issue in oracle to sql 2008 migration using SSIS


Hello friends

I am doing oracle to SQL2008 R2 migration and i want to use SSIS.

Oracle has mainly three datatypes DATE, VARCHAR2 and number. 

I tried without using the transformation it worked but the datatypes like date did not changed to datetime in sql server, even the number datatype remain same.

secondly while doing very first time i got very weired name of the table on sql side. 

Instead of going to dbo schema it shows the name like tom\myname.A_RETURNS.

So how can i resolve both the datatype and naming issue?

Thanks in advance..


MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

Adding Multiple Columns and Rows in GridView without using a Database

This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.

add columns with textboxes in gridview using C#

'm working on a shopping cart in a website and I have my items(which have been added to the cart) in an arraylist. And using these values I've read the rest of the values from the db and and have populated on the gridview successfully.

Custom Editing Behavior for DataGridView TextBox Columns

For various reasons I'm using a DataGridView instead of a ListView, and while configuring the DataGridView to look like a ListView wasn't much of a problem, there's one thing that got on my nerves, which is the behavior of textbox cells in edit mode: It is much too easy to leave the edit mode accidentally, simply by pressing the cursor keys at the wrong time. For example when the text caret is positioned behind the last character of the textbox cell content, and you press the right arrow key

Sorting GridView Columns Manually

We all know that GridView columns can be sorted automatically when SQLDataSource is being used. But what if you are not using SqlDataSource to populate the GridView. Sorting the GridView manually is pretty straight forward task take a look at the code below

dynamically adding sql server columns based on number of files in fileuploader


I want to create a new table to sql database at runtime.  The column names would be "Name", "Date", "Event".  I would also like to have one more column name "Image" but the problem is that since the amount of images will vary, I want the application to count the amount of files in the Multiple fileuploader and then add a image column to the table for the respected amount of files. 

For example if i am uploading 3 files in the multiple fileuploader, the names should be "Name", "Date", "Event", "Image1", "image2", Image3"

I also would like that table name to be name dynamically from the textbox Name when the user enters the information.


I have the following code to make a new table, but I dont know how to name the fields at runtime like previously asked please help!!!


Dim objConn As New SqlConnection("Server=<servername>;uid=<userid>;pwd=<password>;database=master")


How to let user edit selected gridview columns, not entire row



I've got a gridview I would like to let the user edit a couple of columns.  Seems like everything I'm coming across so far makes the entire row editable.  

Hopefully the solution isn't too complicated.  Can someone point me in the right direction?


Need Oracle Data Provider .CS File for Oracle 10g Database connection !



I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where

i can just call the method with my SQL Query


Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");


Plz Post the link if there is any open source !    

What is CultureInfo datatype?


Hi all members!

        whats  Cultureinfo datatype.Please help to know clearly..I ve seen more Sites but i can't able to understand guys!!

        Ex:("CultureInfo culture = new CultureInfo( "hi-IN" );")Embarassed

How to change text in columns in SSRS?


I need to create a complex report and export it to Excel. 

In the first column header, text is displayed as "Hide Daily Columns", but I need the text to change as "Unhide Daily columns" when I click on it and when the text changes the columns under "daily" header (I have 3 columns under this header) present in the report shud be hidden and only weekly columns shud be visible. Any ideas please. I am new to SSRS and tried out many ways but didn't get it.

Toolbox: Distributed Caching, Object-Object Mapping, Blogs and More


This column covers Web application performance with distributed caching, a utility for object-object mapping, and a look at interesting blogs.

Scott Mitchell

MSDN Magazine September 2009

Netting C++: Mapping Templates to Generics


In this installment, Stanley Lippman continues to port his ISO-C++ Text Query Language application to the Microsoft .NET Framework and C++/CLI.

Stanley Lippman

MSDN Magazine April 2007

Netting C++: Mapping Native C++ to the Common Type System


This month Stanley Lippman begins translating the Text Query Language Query class hierarchy from C++ to the .NET Common Type System.

Stanley B. Lippman

MSDN Magazine February 2007

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend