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
Author
Message
Posted Saturday, March 23, 2013 8:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, October 11, 2014 1:13 PM
Points: 24, Visits: 92
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: Today @ 8:12 AM
Points: 7,135, Visits: 12,746
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 Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 2, 2014 1:47 PM
Points: 97, Visits: 363
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