66 Loading most recent file in SQL Server Table from a folder | SQL Server Integration Services

[@carolgs04]

I didn't understand a word you said but your steps were easy to follow. It works great for me!! Thank you!

[@InfinityBigData]

Muito obrigado, o único que vi que deu certo, simples e rápido parabéns

[@SatyarthProgrammingHub]

Muito obrigado pelo seu comentário.

[@rahulgautam511]

Thanks for the videos. I was trying to loading the recent text file, I was getting an error an error again and again (the method or operation is not implemented ), although my code was correct. I wrote the code again, but failed again. But I have noticed that, I had two recent files (means on same time it was updated), that's why package was not running. As ever I deleted one file from folder, the recent filed loaded and package run successfully. So here my question is how we can load two files at a time?

[@SatyarthProgrammingHub]

See, you have to understand the scenario first. Only one can be the most recent files at a given time, two files can never be. Now if you need to load the most recent files then you can use the technique shown in this video. If you want to load multiple files then I have created a video for that as well you can refer to that. Note:- When you have files of the same date and time then there is no point checking for the most recent one. Feel free to let me know if you still have questions/confusion.

[@rahulgautam511]

I know the scenario, just a question came to mind while working, that's why I asked you. Thank you so much....!@@SatyarthProgrammingHub

[@aman26in]

Sir, I have a ftp folder which receives approx 100 nos. CSV files every hour with date time in file name for exmple= NUK_230420_160000_ABCD (Name_YYMMDD_HHMMSS_Location) and we want to load the csv files in SQL table automet every hour basis without duplicate file loading

[@amolpatil8490]

Please share c sharp code. Unable to proceed due to not C sharp code. Please share.

[@ak47ava]

Hello Styarth, My Excel Sheet1 name changes from each file to file, how do i work around that??

[@SatyarthProgrammingHub]

Hello there, in that case rather than relying on the sheet name, please try to make use of the sheet index and it should do the work.

[@ak47ava]

Hello, I am very new to SSIS and i have no idea how to use index, Is there a tutorial or documentation that you can reference in the chat, I would really appreciate Sir!!!@@SatyarthProgrammingHub

[@ak47ava]

Also how would you do this with XLSX file not a CSV@@SatyarthProgrammingHub