@Vipin,

May be you should have a step before each import task that checks for the existence of the file. This will enable you to conditionally skip the task/step if the file does not exist.

Another option is to use a for each file loop which runs over the files and process each file. However, you need to then do some conditional code based on the file you find each iteration of the loop.

my process is

1. Loding data from excel file
2. inserting into sql table
3. deleting that file

where to define checks for the existence of the file have you posted any where on your blog ?

Regards, Vipin jha

Vipin,

I just wrote a post which explains this. You can see it here.

sir thankx for your post , I used the same step in my package but when file is present package is running but when file is not present I am getting the error. and second thing in my package I am having more than 70 excel file connection so do I need to create 70 diffrent script task to validate each file.

Regards, Vipin jha

for a high volume of files like you just mentioned, a for each loop may be more beneficial. So you can iterate over each file in the directory and process each one of them. This can also become a bit tricky if each file has a different structure and needs to be parsed differently.

ya same happening with me, all the 70 file having diffrent meta data so i have to load and use diffrent connection for each file can i used event handlers in this case if yes please suggest

thankx and regards, Vipin