Haha 🙂

Rather than emptying an existing Excel file, you may find it easier to have a blank 'template' file available somewhere on the network which contains only the headers you...

mklein2 (11/22/2010)

---

I'm sorry, it's an other problem.

For Oracle I use an OLE DB connection. This is OK. But after I have to do an other Lookup with an ODBC connection....

If I told you that my car was 'not working', would you...

That is a warning only, not an error and should not cause the step to fail. Are you sure that you provided all of the message text?

da-zero (11/19/2010)

---

You...

To do it more elegantly requires a dynamic dataflow task, which is not available out of the box.

You may find that this gives you a better and more scalable solution...

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.