TDKID,
As BillDHS and steverael previously pointed out, using the OleLoad utility found in the Teradata OLE DB Access Module is a very efficient way to load Teradata from Microsoft SQL Server. Since you mentioned DTS (Microsoft Data Transformation Services), I thought I'd point out that you...
RickH,
To FastExport via OleLoad from multiple tables, first create a "dummy" table on Teradata that has the exact same column data types as the data to be exported. There is no need to insert rows into the "dummy" table. In the OleLoad GUI, select the "dummy"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.