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.