Archives of the TeradataForum
Message Posted: Thu, 11 Jun 2009 @ 09:24:39 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|