There are many ways to do this one and I will need to see your table structure to give you the best answer.

Data Sheet

here is one way to do it, I'm not sure if there are others,

Connect to an instance of Integration Services on the server the MSDB package is stored. ...

How did you create the package?  If you created it using the business intelligence development studio, then it's simply opening the project file, however, if you saved it after performing...

have you thought about merge replication.  That should keep both datasets up to date yet, you can specify which SQL server the end user connects to.

Marvin

Sridhar

That will not work, unless you run SQL Server 2005 in 8.0 mode.  Which basically means that you will not be taking advantage of the new functions of SQL Server...

Another good time to take a backup is before you do major changes to any schema in the database.  The question to ask yourself is do you want to be...

Remember to grant access to the network share to the SQL Server Agent account.  (I'm assuming that you have your backups set to run as a job).  For redundancy, I...

We are using a Dell PE1850 with 8GB of ram.  There are eight intel xeon 2.80GHZ processors and as for as space, it is attached to a dell powervault.  My...

There is no longer a need for an email client when using sp_send_dbmail with SQL Server 2005.  There is also a way to use the CDO object in SQL 2000 that...

I see your problem.  Have you thought of replicating the data and then using some type of ETL process to move the data to the tables with referential integrity.  However,...

Thanks Peter.  Solved a problem I was having. 

What query are you running to get your results?  The problem is your tables are  not normalized as a person can perform more than one role which is why you...

The same thing happened to my test server when the Network Manager made some changes to the firewall.  Something sent a shutdown message to the SQL Server.  I never found...

I understand your total issue now.  There is no simple way to accomplish this, unless you compare the tables on a daily basis as Sean suggested.  You might check with...

Unfortunately, there is no way to know when a field is updated unless you have set up a table to log such events with a datetimestamp.  Triggers can do this...