Load Single value from Text File

Wed, 21 Dec 2016 15:09:57 GMT

Hi,

Im using a text file with a single date stamp to trigger a reload.

My text file looks like this (which has no column heading):

When I try to load the using the load wizard it generates the following code :

Trigger:

LOAD [21/12/2016]

FROM

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Is there anyway to load this as a field? I need to use the following script which loads the value as 'DWDate' :

LET vDWDate = peek('DWDate');

if vDWDate=vToday then

Exit Do

else

DROP TABLE Trigger;

Sleep 50000; // 10000 milliseconds = 10 seconds.

end if

Many thanks,

Re: Load Single value from Text File

sunny_talwar — Wed, 21 Dec 2016 15:12:48 GMT

Try this:

LOAD @1 as DWDate

FROM

(txt, codepage is 1252, no labels, delimiter is '\t', msq);

Wed, 21 Dec 2016 15:17:01 GMT

Perfect and thanks for the quick response!