Solved

SSIS 2008 ORACLE MIGRATION

Posted on 2009-07-15
3
538 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
  • 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

821 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