I'm developed a SSIS Package to load data from Oracle data base to SQl Data base.
I'm using additionally Data Conversion Task to convert UniCode to require data types of SQL Server.
Problem here is Data Conversion task is taking huge amount of time and to to sync 5000 records it's taking 3 hrs .
Please do help me if any one has information to solve it.
Thanks in Advance.