How to get latest folder details dynamically in ssis

Question

0.00/5 (No votes)

See more:

Hi everyone,

I have folders in this path C:\Customer\

Folder Names :04012019, 04022019, 04032019

I want to pick the latest folder(04032019) dynamically and need to process all the files in that folder.

Can anyone please help me how to achieve this in ssis .

Thanks in advance!!

What I have tried:

I know how to get a latest file bu using script task .but i am not sure how to get a latest folder using datestamp.

Posted 4-May-19 7:47am

Member 11931581

Updated 6-May-19 1:51am

v2

Add a Solution

Comments

[no name] 4-May-19 14:20pm

https://docs.microsoft.com/en-us/sql/integration-services/ssis-designer?view=sql-server-2017

Put the date in a db table with a "preprocessor" step.

https://docs.microsoft.com/en-us/sql/integration-services/ssis-quickstart-run-dotnet?view=sql-server-2017

Member 11931581 4-May-19 14:23pm

I don't see anything related in the provided link.could you please check it once

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

#realJSOP · Answer 1 · 2019-05-06T01:52:00

Solution 1

Use a (C#) script task to get the folder names and convert them to datetime objects using the DateTime.TryParseExact method. When you find the "latest" one, set a package variable to the folder name.

Posted 6-May-19 1:52am

#realJSOP

pankaj.todkar@gmail.com · Answer 2 · 2020-10-01T10:12:00

Solution 2

Solution

EXEC master.sys.xp_dirtree 'C:\Customer\,1,0' <pre>

This will give all folder data .. then fetch latest amongst them .. try and test for multiple level by putting 4/5 instead 1

Posted 1-Oct-20 10:12am

pankaj.todkar@gmail.com

Updated 1-Oct-20 10:29am