DTS Programming

[shiekvb]

Hi Gurus,


I need your help on programming the following task.
----------------------------------------------------

Environment:VB /SQL Server


Client1(Sales.mdb) Client2(Sales.mdb) Client3(Sales.mdb) Client4(Sales.mdb)

All these 4 clients are not connected and they are updating one table for example: There are four stores updating the day to day sales data in to the table name sales.

Server(Sales.mdb)


There is one server which is also having the sales table. The price of the sales table will be changing day to day. So whenever a price change occurs, the server sales table will also get updated in the server side.

Again the server and the four clients are not connected. We need to update the changes on either side. We are going to use a laptop and an executive, who will carry the changes and going to run a component which will update these changes.

Now we need to write a Component which will do the followin task.

1. The component should be able to download the sales table records in to a new table.
2. Whenever a changes occur in sales(server) table it should reflected in the dowloaded records.
3. These records are downloaded in a laptop and carried to all the individual client machines.
4. In the client machine when we run the component it should update the price changes to the sales(client1) table.
5. Similarly there should be another component which should download the newly updated records from the client machine to the laptop(this should be later updated in the server (sales) table).


Thanks in advance.

Cheers
shiek