I have a question rearding the Teradata OLE DB drivers. Do they permit an equivalent of MSSQL's "BULK INSERT" operation? When connecting to Teradata through the ODBC bridge, the operation physically results in a series of INSERT statements, which 1) take ages to finish and 2) clog the machine's logs. Thus, I've been wondering if the OLD DB provider for Teradata allows a more efficient access (through the IRowsetFastLoad interface)? If yes, then which version is required for this support? (I'm trying to use MS SSIS to load data to a Teradata DB.)
OLE DB Provider for Teradata does not have BULK INSERT. It does support Parameter Array / Set. That is it can send one INSERT statement with multiple rows of Data. This should improve the overall performance as compared to single row inserts.
Also, OLE DB Access Module (not to be confused with OLE DB Provider) can generate FastLoad script.
If you want to do Bulk Insert to Teradata from VB.Net, C# or some other CLR language, I've created a Managed C++ wrapper for the Teradata Parallel Transport API (equivalent to FAST LOAD). http://tptapiwrapper.codeplex.com/