Hi All,

Thank you so much each and everyone for the inspiring comments. I will change my thinking and no matter what, how many days it will take i'm will not...

Robert Half looks like they help but actually they don't. I can say it with my experience.

Hi Phil,

yes i am using for each loop

Hi..Thanks for the reply i will try it

hi

sorry for not being clear. I am trying to build a ssis package where after imported to sql table the excel file should go to archive folder(to have a history...

Thank you! But unfortunately i work on remote desktop. It is recommended that i should not end any processes on the remote desktop's

Running the ssis package in visual studio 2005.

Sorry. I think i have posted in the wrong place..need to do using excel vba

there are two for loop connectors on control flow. The first for executes but not the inside one. I get the error saying that

Warning: The For Each File enumerator is...

To extend further i followed this link below

http://beyondrelational.com/modules/2/blogs/571/posts/14364/extracting-data-with-ssis-from-multi-excel-file-placed-in-a-folder-having-multiple-excel-sheet.aspx

I did the same way but first for loop executes but doesnot loop with the one inside

Please help

Thanks gbritton1. I would work on that and when the new file comes in. I lost the mappings in ssis. How can i maintain the mappings. Everytime i get the...

Thank you everyone. It worked.

Thank you but i am getting an error saying that "the multi-part identifier could not be bound"

Steve,

All Last Names are unique