Vaibhav Goel
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.