dbTalk Databases Forums  

Extremly slow data load to Teradata

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts Extremly slow data load to Teradata

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Extremly slow data load to Teradata in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Black Bird
 
Posts: n/a

Default Extremly slow data load to Teradata - 09-20-2006 , 02:39 PM





I am loading data from SQL Server to Teradata using DTS. I am using OLE DB
connection. The data loading process is too slow. 1,000 records per minute.
Is there a way I can expedite this process. I have over 100,000 records.

I would like to avoid mload or fast load utility due to some constraints.
--
Black Bird

Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top