I am not sure I would use transactional replication for what you are doing, but you do have a few options if you really want to do this.

The simplest would...

That's pretty simple if your schema is close to the same.

In the control flow, you will need an execute sql task and a data flow task (with a control...

The short answer is that it can probably be done without writing any significant code or using a script component.

It will really depend on what you consider bad data and...

Dealing with this as a deployment issue would probably be the best approach. Create a process or an application that will apply changes across all of the databases. ...

You are not likely to run into errors from adding procedures to the master database.

What you do have to watch out for is making sure you appropriately back up your...

My first guess would be that you hit a DTC timeout. This will cause DTC to cancel all of the related transactions. This may not be the same...

I don't advocate adding procedures to the Master database, but this will solve your issue.

If you add a procedure to the Master database (and the dbo schema) and use a...

You have not posted much information, but this should be pretty straight-forward.

Select your source data using a DataReader or OLEDB Source, look up the surrogate key from your dimension table,...

There is no NVARCHAR(MAX) data type for an SSIS variable, that is only for T-SQL variables. See my previous post for options when running large queries in SSIS.

I don't know about your date issue - that is weird.

As for the service pack - SQL Server service packs (and all MS products for that matter) are cumulative.

So, if...

You could do this with linked servers as suggested. Look for linked servers in BOL for some details on how this works. This will allow you to write...

It depends on how your query changes. If it is a small set of 2 or 3 different queries based on some criteria, you can use the SQL Command...

That's an interesting article with some good tips. What is actually being done in the article (seeing if a record exists and then if it does, if the record...

If I am following, you have a data flow that contains records with a few indicators. The indicators determine if there should be some insert and updates made.

If each...

It depends on the version of Sybase. I believe there is one for versions 11 and newer. For earlier versions of Sybase, I have not found an OLE...