Archives of the TeradataForum
Message Posted: Mon, 12 Jul 2004 @ 21:09:45 GMT
Could you give me some hints (sample code etc.) on how to do that?
Currently, I created a VC++ program that go through a set of FastExport templates to export the data into text files. Then, the VC++ goes through a loop and takes each text file and BCP that into SQL Server.
Actually my VC++ can write data into text files by running Teradata SQL using ADO connection. But, I found it is very slow (30 minutes for 10M records) and hence went for FastExport.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|