Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ramkirangj
Starting Member
7 Posts |
 Posted - 2008-12-03 : 02:41:11
|
| HII have two servers example s1, s1.In server s1 i have tables example t1, t2, t3In server s2 i have table t4From the data that is there in tables t1, t2, t3 in server s1 i have created a view which gets me the data into table t4 in server s2.So when ever there is change in the output from view in server s1 then that change should reflect in the table t4 of server s2.So please help me out. How to do this. |
|
|
ramkirangj
Starting Member
7 Posts |
Posted - 2008-12-03 : 02:43:44
|
| One thing i forgot to mention the server s1 is sql server 2005 and server s1 is sql server 2000 |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-03 : 02:55:42
|
| Does that mean you need to trigger dts package only when source data changes? |
|
|
|
ramkirangj
Starting Member
7 Posts |
Posted - 2008-12-03 : 04:21:44
|
| Yes |
|
|
|
|
|
|
Creating DTS Packages in sql 2000