Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > General .NET
|
General .NET For general discussion of MICROSOFT .NET topics that don't fall within any of the other .NET forum subcategories or .NET language forums.  If your question is specific to a language (C# or Visual Basic) or type of application (Windows Forms or ASP.Net) try an applicable forum category. ** PLEASE BE SPECIFIC WITH YOUR QUESTION ** When posting here, provide details regarding the Microsoft .NET language you are using and/or what type of application (Windows/Web Forms, etc) you are working in, if applicable to the question. This will help others answer the question without having to ask.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the General .NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 14th, 2005, 11:23 PM
Authorized User
 
Join Date: Jan 2005
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to Incorporate DTS( SQL2k in Web Application

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







Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with DTS programming application khanhmy264 SQL Server DTS 3 May 20th, 2008 04:50 AM
Difference between web application and web site manojm39 ASP.NET 2.0 Basics 2 August 10th, 2007 09:06 AM
store insert/update date/time stamp in sql2k db alexdcosta ASP.NET 2.0 Basics 0 June 22nd, 2006 05:44 AM
DTS Package with windows Application elghoul_girl C# 0 March 7th, 2006 06:45 AM
SQL7-SQL2K collation problems dhulse SQL Server 2000 2 July 6th, 2004 03:47 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.