Using Data Transformation service functionality in a web application 
Author Message
 Using Data Transformation service functionality in a web application
I am building a web application that requires me to read various db
formats (mdb, .xls, txt, dbf) etc. and convert db formats into SQL
Server database table. This functionality in many ways is doing the
same things as Data Transformation Services of SQL Server.

Question.
1. Is it possible to use Data Transformation Services via the Web?
2. Are they tools that are web enabled that perfom similar for
functionality as Data Transformation Services.

Patrick

Sent via Deja.com http://www.***.com/
Before you buy.



Fri, 28 Jun 2002 03:00:00 GMT
 Using Data Transformation service functionality in a web application

You may control DTS through stored procedures, or through Active script
using the object model.....DTS runs on the server, however which may be a
problem for you..

--
Wayne Snyder MCT,MCSE, Sql Server MVP
IKON Technology Services, C{*filter*}te, NC Education
(Please respond to newsgroup unless otherwise requested.)



Fri, 28 Jun 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Using Data Transformation Services in web application

2. Btrieve to SQL Server using Data Transformation Services and Data Direct ODBC Driver

3. Exporting Tables using Data Transformation Services

4. SQL6.5 to SQL 7.0 using Data transformation services does not copy indexes etc over

5. Ann: Microsoft SQL Server DTS: Tips and Tricks Using Data Transformation Services chat

6. Sample Application using Web Services on DB2 and WebSphere

7. Sample Application using Web Services on DB2 and WebSphere

8. Previous - Next functionality for web application

9. Performance Issues using Excel 2000 Pivot Table functionality and Analysis Services

10. Reporting Services - Using subscription web service

11. Data Transformation Services

12. SQL 7.0 Data Transformation Services


 
Powered by phpBB® Forum Software