The Web application is developed using ASP.Net &
VB.Net.
1. How to incorporate DTS(Data Transformation Services) programming instructions in a web page so that we can dynamically allow the user to feed from to period and other parameters and then based on these parameters, pickup data from dbase III as a Source and the update this data in SQL2000 Server RDBMS Table as a destination and also vice versa i.e. from SQL Table to dbase III.
2. While updating the server may fail thereby user not knowing as to how much of the data is updated, hence may send same data more than once for updation.Hence, using DTS Wizard directly many not be suitable.
How to handle such situations programatically?
Regards,
Dilip Nagle