You can either dynamically alter the connection manager (which I have not had a lot of luck in being stable) or make the connection manager always point to the file...

Ok, I made my own schema to simplify the example a bit.

Rather than dealing with attempting to keep the ID from the original table, I ordered the INSERT.

Then, because I...

You need to get yourself a hobby.

How would doing anything with hexidecimal be fun?

You configured the replication, so this will depend on the options you have selected.

Some replication is one-way - snapshot replication or log-shipping for example. Merge replication is two-way. ...

The comparison is relatively usless (in my opinion) because unless you intend to do an in-place upgrade and retain your original hardware (which I would not recommend) you will not...

Older versions of Sybase do not have OLEDB providers. I would assume you are using a version that you only have an ODBC provider for. If you are...

By SQL Command, I meant the Execute SQL Task in the control flow, not the OLEDB Command transformation. You could use this to insert or update records at key...

You are in a SQL 2005 forum - if you actually were running SQL 2005 this would not be that complex since you get a rownum function in 2005. ...

SQL 2000 will not run well in WOW on a 64 bit system.

You need to install a 32 bit OS if you want to run 32 bit SQL Server.

Make sure you have SET NOCOUNT ON - RS does not like the rowcount output.

You need to use RCmd or another utility to remotely execute something.

Just look in the TempDB database:

CREATE TABLE ##tmpMyTable (FieldA INT, FieldB VARCHAR(10))

SELECT * FROM TempDB.Information_Schema.Columns WHERE Table_Name = '##tmpMyTable'

Does your search criteria start with a wildcard? If it does, an index will not help anyway. If your search criteria is typically "starting with" or the entire...

Are the MAC addresses the same?