Archives of the TeradataForum
Message Posted: Wed, 29 Dec 2004 @ 15:25:01 GMT
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
|