You are grouping by the title, not the results of your case statement.

You probably want this (I'm not spending the time to clean up the format):

[font="Courier New"]Select c.ConsultantID,

...

You need to be more specific about the type of replication, the type of articles you intend to replicate, data types, etc.

The short answer is yes, you can replicate from...

"SQLServerIsBadDatabase" is being taken as an alias for the table name.

Don't over-index your table.

You have a lot of writes happening and every insert or update has to update the appropriate indexes. You will also get fragmentation on indexes pretty...

You need to configure logging and get the entire error messages. Everything you need is being covered up by the elipsis (...) areas of what you posted.

I would guess...

Right-click in an empty area of your control flow and select "Logging" from the context menu.

You can configure your package to log to a number of different sources, but logging...

That is basically what Service Broker would do - without writing the code to manage the queues on both ends.

What you are describing is what merge replication was designed for. It does, however, present some interesting issues. If you have the ability to modify schema, you may...

Did you set the server in the project properties? Is it the correct Analysis Services instance? Can you connect to the AS instance through management studio?

The error is...

You may want to use the RECOMPILE keyword. If the first time you run the procedure it is with the 'All' value, the execution plan could get stuck with...

You have a lot more to look at before you will be able to make a decision, but my first impression is that transactional replication is probably not going to...

I have moved lots of data between Oracle servers, and some data (1-2gb per night) from pretty old Sybase databases to SQL Servers.

SSIS will devour bandwidth as needed. No...

Nope.

But if this is just because you are lazy, right-click on the table in management studio and generate an insert script.

The SP could be it, but I will assume you are using sp2 everywhere.

I would start with it being a permissions issue. Does the account executing the package (your...

You either did not add a grid to the report, or you added a grid and suppressed the detail rows.