Load Single value from Text File

[#1]

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,

[sunny_talwar · Accepted solution]

Try this:

LOAD @1 as DWDate

FROM

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

[#3]

Perfect and thanks for the quick response!