112 How to import the most recent file from folder using ssis

how to import the most recent file from folder using ssis

Download the file\script used in the Video from below link

how to import the most recent file from folder using ssis
SSIS -How To Get Most Recent File from Directory And Load
How do I get most recent from a folder and load to a table?
How to get last modified date of a file in SSIS?
How would you get the oldest file from a folder in SSIS?

Happy Learning.

[chandrasekhar-rfbg]

Very much impressed with the presentation. I want to know the detailed job roles of SSIS developer and SSIS support. Please compare the roles between them with examples. Thank you. 🎉

[NanduHSN]

Hi Aquil, thanks for the nice explanation, I do have question, when I try to open script task to write c# code application throws an error as "cannot show visual studios 2015 tools for Application editor.When I searched found that I might be missing Microsoft Visual Studio Tools for Applications x64 Runtime 3.0" was the issue. This was installed corporate account, dont have permission to install any missing software ..And also the above solutions can be done without using script transformation ??

[murthymamidi]

Hi Aqil,
Good Morning!!
Thank you very much for sharing wonderful videos.
I have one scenario like, i have a file with datetime in a folder and every time we will get files with datetime and we have to process the recent file with date time and pull data from the file into sql server.so, shall i use this package for my reference .if not can u please help me.
Thanks.

[gracec]

will the package execute as soon as a new file is in the folder? or would i have to set up like a job to execute the package at given times?

[oguzolgun]

Hi Aqil, thank you very much. I did not expect such a quick response. you're really amazing and helpful. I hope your channel will get deserved interaction.

[sureshgpr]

Hi, i have a files with dsteand time like ac_20230314084452, like, 3 or 4 files in a folder different date and time so how to load most recent file in dstabase table

[amarnadh]

Hi How to import last modified multiple files from one folder
If i give, start like the file name it has to import all files what ever starting with that name

Hi Aqil, Thanks again for the video. Additionally, can you please show us how to check if the record count > 0 (excluding header) for the last modified file? Ideally, i wouldn't want to import the file if the last modified fille has 0 records in it, thanks

Hi Aqil, don't bother - I figured ot out by viewinhg '36 Load a file only if it contains more than 0 records using SSIS', thanks bud

[deandrechisolm]

Thanks for the tutorial! Any reason why everything gets deleted in the Script Task after running the job once?

[AhmedHassan-wtlv]

as usual amazing video thanks a lot it will help a lot

[kiranshetty-xbmn]

Hi, thanks for the video. Can u please let me know how to get the file from nework location or shared drive instead of local folder. Can u pls help me

[Acito]

All of your videos is impactly resourceful

[priyankakini]

Very Useful. Thanks. But I'm getting error and unable to solve. Could you please help.


at target, Object[] arguments, Signature sig, Boolean constructor)
at obj, Object[] parameters, Object[] arguments)
at obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at