SSIS Package To Check for a Flat file And Return True/False
Posted on 2009-04-16
Hi Experts, I have to create an SSIS Package to Check If a Specific File Exists in a Folder. If this File Exists then it should return True and if it dosent exist it should return False. What I have to do actually is, I have to Schedule a Sql Agent job in that the first step is to check if a file (filename_04152009_1515) exists in a folder on my network, and if this file exists I have to Proceed to the next step and if this file dosent exist, I have to send a mail to the User telling that the data file is not there, please help me Thanks in Advance.