Charmer (12/18/2012)
the task gets failed when a file is unavailble in the directory if it is specified in the table. How to avoid such cases?
Two options:
(1) Do a file existence check for each file, using xp_fileexist, a DOS command, a VB script, Powershell or however else you like to do it.
(2) Import the file list into a staging table and join that to your table of files so that you get a list that only includes files that exist.
John