Steve, you make no mention of the BlackBerry in your article. While it may not be quite as much fun to use as Android, iPhone, WP7, it's a pretty efficient...

That won't make your problem go away.

This sounds like a job for backup/restore to me 🙂

The rest of this thread is about transferring objects between a 2005 database and a 2008 database - that makes two databases. So I mean the other one, presumably on...

Assuming you're using a dataflow to get data from A to B, you can use a Conditional Split to redirect your '0' data out to a CSV file while your...

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.