And the problem you have is just with the 2005 database, or with both? Are your db's both set at 90?

Where is the SSIS package running? On 2008 or 2005? I would expect it to work if using a 2008 package (though haven't tried it).

SSIS does not natively handle dynamic column mapping in dataflows, if that is what you are referring to?

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...