Thank You Scott,

I tried,
1)    EXEC sys.xp_cmdshell 'DIR \\tntfappl11.companyname.net\Project012\1.Cust\LDSH\4\7\*.csv';
    Got error  "The EXECUTE permission was denied on the object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'.   

2)  EXEC...