How to check a file exists

[sedgely]

i am building a dts job to import a text file, however on occasions the file may not exist. is it possible for the DTS job to check for the existence of the file before attempting the import and end the job if it is not there?

Cheers, Craig
Si fractum non sit, noli id reficere

 

[nigelrivett]

http://www.nigelrivett.net/DTSActivexFileExists.html

You can also use the FileExists method to check for the file - the link above checks to see if the file is empty.



======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.