SSIS 2008 ORACLE MIGRATION

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
fabiogaravelliAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
PedroCGDConnect With a Mentor Commented:
are you mapping the columns in the destination component!?
regards,
Pedro
0
 
fabiogaravelliAuthor Commented:
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
 
PedroCGDCommented:
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
All Courses

From novice to tech pro — start learning today.