Load data via SQL Server DTS

UDA
Enthusiast

Load data via SQL Server DTS

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.
2 REPLIES
Enthusiast

Re: Load data via SQL Server DTS

I am doing exactly what you are suggesting, its a datapump task in DTS. I think that Teradata is issuing commit after inserting single row. Thats the reason why its so slow.

Looks like you have a solution for that...
Senior Apprentice

Re: Load data via SQL Server DTS

Hi Black Bird,
DTS probably sends one record after the other, that's slowing down...

If you're on V2R6+ there's an array feature available, but i don't know if DTS/OLE DB supports that.
If not you still could submit a BTEQ script where you can add a PACK command to speed it up.

Dieter