May 17, 2010 at 2:05 pm
Hi I m looking for a way to compare a primary key value in Oracle with values in SQL Server - IN SSIS
1. I made sure that the data types are compatible
2. I m trying to avoid making a copy of the Oracle data to another SQL server table.
What component from SSIS could i use?
Could someone help me with this
Thank u
May 17, 2010 at 5:42 pm
Not sure how to do it via SSIS but, if you have access to the Oracle instance...
1- Log on via sqlplus and do... "desc table_owner.your_table_name' OR
2- if logged as owner of the table do ... select * from user_tab_columns where table_name = your_table_name OR
3- if logged as sysdba do ... select * from dba_tab_columns where table_name = your_table_name
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply