Thank you so much for your video. Can you give me a video that you can load Excel files in order which the same with csv files. I have tried many time the same with your work in csv for excel files. But I get trouble invariable of Excel filename or move the Excel files to Archive folder.
Why do you use TotalFiles = Directory.GetFiles("*").Length and then later you use files = DirectoryInfo(...).GetFiles("*.CSV")? If there are non CSV files in the folder these counts will be different. Also you don't need both OldestFile and FileName because they are the same just the path is different. You're variable names are inconsistent too.
At the moment, I am traveling thus did not rechecked it. Yeah the code might not be optimized, you are correct there is a scope of improvement of code and I will try in the future to double check and use the optimized code. Thanks for pointing this out.
Hello Aqil..thanks for this video..can you please help me with one scenario recently I faced. I have 1 file having multiple columns and I want to load few columns to one destination and a few columns to another destination then how could we achieve this..thanks in advance
You can use multicast transformation to generate 2 outputs and then map the columns accordingly to 2 different outputs. I will try to make a video on it.