Thanks. I think the issue is Report Builder 2.0 and 3.0 work on SQL 2008 R2, but Report Builder 3.0 works ONLY on SQL 2008 R2 (not SQL 2008).

🙂

Thanks.

Any VB.NET expert who could share this ?!

Thanks.:(

Thanks for the answer.

Two things I have to do right now.

First is THANK YOU for the detailed answers for this rookie!

Second is I need to get the book (which already is in your...

Thank you.

You mention when they got "fired", but are they created by the system or I have to manually produce them?

Some questions, what does the "base"and "Me" mean ? I...

Everything on the same box.

Thanks.

No, I do not have a linked server. All INSERTS and UPDATES are aiming to the same table/database/server/machine.

Thanks.

Thanks.

The error message is

[SQL Server Destination [794]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. ...

Yes, everything on the same machine.

OK! I am not alone. Re-install it and keep on trying until they are all there.

Thanks.

Thanks for the time.

One more hero to come for the rescue. Thanks.

I have done a simple test (you can put on any testing database)

This to create a simple table and data filling

create table...

Yes, both of the data come from the same database and table.

OLE DB has 100% data and Lookup has a filter to restrict to only one line (for testing purpose).

One...

Thanks for the reply.

Sorry for not being clear. The error message is "[Lookup [247]] Error: Row yielded no match during lookup. "

But when I Preview under Lookup there is...