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