Data flow task consuming time due to data conversion task

• ramineni.suresh661

  Mr or Mrs. 500

  Points: 554

  More actions

  March 23, 2013 at 8:42 am

  #270363

  Hi All,

  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.

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  March 23, 2013 at 5:04 pm

  #1600080

  The image did not post correctly. Can you please try posting it again?

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato

• //Ravi

  SSCrazy

  Points: 2612

  More actions

  March 25, 2013 at 6:00 am

  #1600252

  Data Conversion task is a Syncronous transform, it shouldn't be taking 3hrs for 5,000 records. Please post screen shot of your package.

  Alternatively, you can use T-SQL to conver the data Select cast (column 1 as datatype) as Column from Table

  ------------
  🙂