?
Solved

SSIS 2008 ORACLE MIGRATION

Posted on 2009-07-15
3
Medium Priority
?
546 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 2000 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
This video shows how to recover a database from a user managed backup
Viewers will learn how the fundamental information of how to create a table.

568 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