Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 11 Jun 2009 @ 09:24:39 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   OLeLoad Multiload problem
 
From:   Seears, Andrew

Hi

I am using the OleLoad (Multiload) tool in TTU 8.2 for the first time and I'm trying to dump multiple tables in a SQL server into Teradata. I believe that multi load allows up to 5 table loads from 5 different flat files but wonder if the issue is a SQL server problem and trying to extract more than one table at a time. OleLoad creates the script for a single table load which I've then used as the basis to try and load two tables. I have tried various permutations of script including grouping the various command statements eg create table, layout, insert etc. together or running one complete table request followed by another but without success.

Grateful if anyone can advise firstly whether it's possible and if so the correct syntax and order of the commands.


Regards

Andrew



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016