Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 29 Dec 2004 @ 15:25:01 GMT


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


Subj:   Fastload from within DTS
 
From:   Hassinger, Bill

I am trying to run a Windows Fastload script from within a SS2000 DTS package. I can successfully run the program, but I would like to take the logon line out of the script and put it in a little file that can be maintained more easily and used by multiple DTS jobs.

The fastload OS command appears to call the bat file, but when I tried using ECHO to return the LOGON command it was not accepted. Is there another way of retrieving a LOGON command line from inside a Windows Fastload script?

     **** Fastload Lines ****
     Sessions 8,8 ;
     OS mecpw.bat
     drop table xxxxx.yyyyyyy;
     /* Required error tables */
     drop table xxxx.err1;
     drop table xxxx.err2;

Thanks



     
  <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