Link to home
Start Free TrialLog in
Avatar of Vaibhav Goel
Vaibhav GoelFlag for India

asked on

SSIS I need to get the most old file from a folder in the SSIS package.

Hello EE experts,
I have a folder and I need to get the most old file from a folder in the SSIS package.
Is it possible? What transformation I can use for this?
Appreciate the help.
ASKER CERTIFIED SOLUTION
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Vitor Montalvão
Do you know any .net programming language?
If so, you can add a Script Task and build the necessary code for that. If you perform a search in the internet for sure you'll find some examples in C# or VB.net.
This one is from MSDN and even isn't exactly what you're looking for it has the base for you start working with.