how to check if a file exists

Question

how to check if a file exists

Da Posh

SSC Enthusiast

Points: 135
More actions
July 24, 2006 at 6:58 pm

#114813

Hi, can someone please tell me how to check if a file exists in SSIS. if it exists then contiue with the process else send a mail.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Rob-242869 SSC Enthusiast Points: 130 More actions · Answer 1

Im sure there are easier ways but try adding a Script task and use on of the IO File objects to check for the file then depending on the result pass or fail the task

Steve-335899 SSChasing Mays Points: 639 More actions · Answer 2

You can always use the File.Exists function in an ActiveX Script tast using the Java Language. I would check on MSDN online for sample code to help you do this. This will check if it exists and continue package.

Jamie Thomson SSChampion Points: 11805 More actions · Answer 3

Rob is right.

System.IO.File.Exists(filename)

will do the job for you.

-Jamie

Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson

Da Posh SSC Enthusiast Points: 135 More actions · Answer 4

thanks guys, i used script task to check if the file exists. this link helped too - http://blogs.conchango.com/jamiethomson/archive/2005/09/14/2149.aspx