Hi All,



Has anybody implement this type of data conversion? I need to upload a CSV 

file to a web server then execute a dts package that will upload the CSV 

data to a sql server on a different server. Uploading of CSV file is 

fairly easy, my problem is I cannot execute the dts package, I already had 

the code that will execute the dts package (dts.package object) but it 

only works when the web server and the database server are on the same pc.



Regards to everybody and I hope someone can help me.



Thanks in advance

Dennis

I believe you need to have the SQL Server client utilities (a.k.a.

enterprise manager) installed on the server.  Although, you shouldn't

need the whole SQL Server Install, just the management utilities.  This

installation will put the COM object model for DTS on the server.  With

this, you can call the dts objects from code, and even build your own

dts package dynamically, using the DTS engine running locally, and

connect via OLE-DB to the remote SQL Server as a destination or as a

source for data.  In your case, the local DTS engine could pull the data

from the local CSV file and push this data to the remote SQL Server.



I have done this for very large data loads, to utilize multiple servers

to participate in the data migration to a single SQL Server.  Each of

the multiple servers used dts to pull and process data, and

simultaneously pump data to the single SQL box.



Good luck





---

Bruce Pezzlo

MCSD & MCDBA

PLUM Computer Consulting, Inc.

bpezzlo@p...





-----Original Message-----

From: Dennis Dulay [mailto:eenaian@y...]

Sent: Monday, June 25, 2001 9:23 AM

To: ASP components

Subject: [asp_components] Executing a dts package on a separate server







Hi All,



Has anybody implement this type of data conversion? I need to upload a

CSV

file to a web server then execute a dts package that will upload the CSV



data to a sql server on a different server. Uploading of CSV file is

fairly easy, my problem is I cannot execute the dts package, I already

had

the code that will execute the dts package (dts.package object) but it

only works when the web server and the database server are on the same

pc.



Regards to everybody and I hope someone can help me.



Thanks in advance

Dennis