Question about by Import oracle data and field is null

Question about by Import oracle data and field is null

• anyuser

  Hello Buck,

  I work with SQL server 2005 and Oracle 7.

  Olaf

  
  

• kennm

  Hi Buck,
  What is the problem. I have a made a SSIS, in VS2005, with an ole db source, settings to the oracle db, and an ole db destination, settings to sql 2005 db. When i look in preview query result, via OLE db Source editor > Preview, afield contains '<value too big to display>'. This field is a datetime oracle field and it's empty. How do i check if it's empty And what do this field then get for an value so that i don't get problem with importing it in to SQL
  
  Thanks in advance
  
  Olaf
  
  

• Gazuga

  Olaf - SQL Server has several methods to export and import data, as does Oracle. For most data cleansing issues, the simplest way to eliminate data format differences is to export the data from Oracle to a text file and then import that to SQL Server. If you're looking for something that is simpler, such as using SQL Server Integration Services (SSIS) then you'll need to check the data types on both systems to ensure that they match up. You can also "push" the data from Oracle using their export tools. Whether you pull the data from Oracle using SSIS or push it from Oracle, both servers need to have the latest client drivers for each other.
  
  

• rgalgon

  It may be helpful to have a few more details. Which version of SQL Server and Oracle are you using And which method and tool are you using to import data
  
  

• yanamandra

  As I mentioned, you'll need the latest drivers on your SQL Server System for Oracle. Also, you can check the data you're about to import using the OPENQUERY statement in SQL Server. Look in Books Online for more information on how to use that statement.

  
  
  
• Question about by Import oracle data and field is null