Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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
Author
Message
Posted Saturday, March 23, 2013 8:42 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, June 2, 2016 6:42 AM
Points: 26, Visits: 95
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, June 24, 2016 4:38 PM
Points: 7,917, Visits: 14,266
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


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 23, 2016 12:21 PM
Points: 108, Visits: 431
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