They will run side-by-side without issues - but remember that SQL 2008 has not been released. Installing a release candidate or beta on a production server is probably not...

SELECT *

FROM TableA a

JOIN TableB b ON a.col1 = b.col1

WHERE colID = 123

If both tables have a ColID column, your query will give you an error. So,...

Perhaps you could post the stored procedure and the execution plans from both servers.

You can dynamically change connection strings.

http://www.sqlservercentral.com/articles/Development/2945/%5B/url%5D

If you are using NT authentication, you should be able to build a data source based on the current user.

Here are my thoughts.

Notification Services - I don't think this would help you at all. It is designed for notification of user-defined criteria being met on a SQL Server....

There is nothing built into replication on the SQL Server end to pull from a DB2 database automatically. The DB2 database would at least have to be able to...

True, but what are the odds we're both off our meds on the same day?

I saw the post yesterday, but I did not have an absolute answer.

Replication, Log Shipping, and Mirroring will all work with server names or IP addresses. So, if you...

Let me add that I have never tried to do this. I just think it will work.

Of course, if Gail and I both think it will work, the odds...

Yes, this is all assuming you have a regular full backup and transaction log backups in between.

Don't restore last night's back - restore the latest full backup BEFORE the records...

RE-hard code your bulk insert task.

Once you have done this, you will find a connection manager has been created for your text file. You need to use the expression...

Yup IsSorted will have no impact on performance.

How many columns are in the view? Remember that the OLEDB Source has to take the data and create a recordset out...

The merge join component acts similar to a T-SQL join. A Lookup somewhat does as well.

I would recommend you purchase a book on SSIS. Also, MS provided sample...

Replication would be an option, or possibly mirroring / database snapshot.

Also, if you like using SSIS, you could use the Slowly Changing Dimension transformation, a merge join / conditional split...

You need to use a connection manager and set the path for the connection manager using the expression. The bulk insert task does not accept just a path.