Unless the tables are the same in structure (field names, types) and have exactly the same destination (table, field names), you'll need four separate dataflow tasks anyway.

If that's the case,...

My answer will provide roughly as much detail as your question.

Yes.

Accepted good practice is to move a file which has been processed to a separate archive folder - then you don't get a mixture of processed and unprocessed in the...

Could you have a task that runs first which renames the file, dropping the h:m:s bit and then feed that into your dataflow as normal?

Yeah I know. I was in full artistic composition mode while you nipped in and posted a...

da-zero (11/9/2010)

---

I don't have access to my code right now, but I'll post a script later that will check a given directory for files that match a certain filename, with...

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.