How to Load Multiple Excel Files to SQL Server Table & Archive them in a folder with Datetime | SSIS

[@Karenshow]

Hello, I really like your videos, but I don't understand a word of it. Could you please add captions in English please? Thanks

[@rahulgautam511]

I have created two packages similar to this video, which means I took the similar source folder and archive folder in both cases. But when I run the packages, they throw an error "the process cannot access the file because it is being used by another program" in both cases. When I changed the folder paths, packages run perfectly fine. Could you please advise why this is happening? Does it mean we can't have the same paths? Thanks, Satyarth

[@SatyarthProgrammingHub]

It is not about the paths but about the input-output operation management by the OS. When a file is being used by one user or process and another user or process tries to access that OS does not allow that and that's why we get "the process cannot access the file because it is being used by another program" error. Please let me know if you still have any questions/confusion.

[@rahulgautam511]

I got it. Thanks@@SatyarthProgrammingHub