It seems that you are hoping that someone here will actually write the code for you. The people who respond here are extremely helpful, yet are generally pushed for time...

I - along with many others on this forum - think the same...

Please explain what you mean by 'report'?

From what you are describing, it just sounds like a straight INSERT.

Use an Execute SQL task in your Control Flow to get the count and assign it to a variable - then use a precedence constraint to direct flow to your...

To use SSIS variables within the Execute SQL task, use an Expression to set the appropriate property of the task.

You are using a lot of guesswork here.

A quote from the original post:

how to find out whether any file is present in the specified folder.

Note: we dont know about the...

True 🙂

Directory.GetFiles will probably do the job.

But so will a FEL, without the need for any code.

What does this give the OP that Steveb's post did not?

Depends on what you will do next.

You might just be able to use a Foreach loop and put your 'file(s) found' processing inside it.

You have pretty much just repeated your initial post without providing the information requested by the respondents. Why should others make the effort to help you if you cannot be...

Several ways of doing this. One is to create a FEL that processes *.txt and then another that processes *.csv.

A data flow within each FEL takes care of the difference...

What I am unsure about is whether Excel interprets the string "20%" correctly as a numeric percentage and does the formatting for you.

If it does, you should add a derived...

Sorry - I'm in the middle of a course...

Why are you doing this? Is it because you want a numeric value formatted as % in Excel?

It's because they don't know how to use Access and Notepad is ungainly to use - understandable, I think. But we as IT people are in a position to educate.