Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Data flow task consuming time due to data conversion task Expand / Collapse
Posted Saturday, March 23, 2013 8:42 AM


Group: General Forum Members
Last Login: Thursday, April 16, 2015 9:57 AM
Points: 24, Visits: 93
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.

Post #1434617
Posted Saturday, March 23, 2013 5:04 PM



Group: General Forum Members
Last Login: Yesterday @ 11:45 AM
Points: 7,288, Visits: 13,142
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
Post #1434633
Posted Monday, March 25, 2013 6:00 AM



Group: General Forum Members
Last Login: Saturday, October 3, 2015 11:45 AM
Points: 106, Visits: 411
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

Post #1434850
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse