Hi Guys
Could someone please assist me.
I've inserted a stack of file names into my db, using a data flow task from a flat file.
ie:
FileNm
--------
***.YYYYmmdd-*.txt
Now I need to fpt the latest file onto my local & insert the data into my db tbl.
but I dont know how to set the RemoteVariable equal to the result from my select.
ie:
User::[sql result]
I've been at this and & would appreciate any help.
1