Fraser_Admin
asked on
sqlserver 2005 linked server to folder get filenames
in sqlserver 2005 i have a linked server which refers to a folder on the local hard drive. how can i traverse that folder so that i can capture the file names which are in it for processing.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks that did it
ASKER
Set @sql = 'SELECT Trim(BOL), GrossLbs, TareLbs, Date, [%Dry] FROM ' + @myFileName
SELECT *
FROM OPENQUERY (LincolnJU,@sql)