Solved

SSIS 2008 ORACLE MIGRATION

Posted on 2009-07-15
3
539 Views
Last Modified: 2013-12-19
Hi all,
i have do a dtx package with ssis 2008 to copy table from oracle 9 to sql server 2008
First i have do is a package that create the database and the correct schema(create table...),
second a  package with Data Flow thate after selected the table in oracle and mapping the field,from Origin to Destination must transfer the table , when i run it i not receive any error, but the log generated by the SSIS environoment tell me that the nuber of row transfered is 0.Any Idea ?
the second is that in SQL server DTS i have a item call Transform datatask is in SSIS 2008, something that i will use to do the same ...this because on SQL 2000 using only target - destination i can put n transform data task, but not in SSIS 2008...
Any suggest is appreciate
bya all
0
Comment
Question by:fabiogaravelli
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 22

Accepted Solution

by:
PedroCGD earned 500 total points
ID: 24861487
are you mapping the columns in the destination component!?
regards,
Pedro
0
 

Author Comment

by:fabiogaravelli
ID: 24862711
Hi pedro, if you are talking about the mapping tab where is the table of origin and the destination table , yes i have map all the field ex:
origin col1 -> destination col1... and so on...
it's very strange because when i execute the job i not receive any kind of error. all seems work ok, just on the end of the log of SSIS i see that the number of row transfered is 0...
All permission on SQL it's ok , the credential are under sa .. so think that are ok...
I create the the destination database before this process ... this is create due to SQL script executed in SSIS.. but this is ok... Any idea or suggestion?
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 24867819
Could you attach your package herre, or if has some sensitive info to my email?!
It'll be bettter to take a look inside
Regards,
Pedro
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question