I tried that but how can i config the package variable which holds the value and depend on each otheer. like filename for file name. filepath source folder. sorce filepath...

Thanks for the reply,

also i have for each loop in the package. the job works fine when the file is there but if there is no file to process it...

no no.

I am trying to do update if exist else insert

thanks

Hi Thank you very much for your help. It is working fine now!! Appriciated you help and patient with me!!

it is only doing to one worksheet then!!

name = file name in worksheet

filename = file name in worksheet production month = 11/1/2008 day =2 test1 = 424 test2 = 647 test3 = 416

filename = file name in...

then how will i write the insert and update please guide me!!

thanks

what?

yes

hey,

it also prints the name as well.

this is so wierd now.. if i put the print message on insert it does all insert but not update and it duplicates the...

no i does on insert but rest of them update like if worksheet has data till 24 rows it will run update till 24 but insert is one only!!

Hi,

i did that already and that's why i said that it only does one insert per worksheet(total count of worksheets are 29) and it updates the same reocords.

thanks

Pat

here is the thing when i did that the you u suggest.

I only does one insert and rest of them update. and file has 29 worksheet so i get only...

this is the sample file and teh data start from row 8 and ends at row 31

so the row count always be 31 form starting row 8 and ending row...

i am blank now what do i need to do and how?