Solved

SSIS 2008 ORACLE MIGRATION

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
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…

627 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