|
 |
asp_databases thread: SQL Server DTS from ASP?
Message #1 by pzahos@s... on Thu, 22 Mar 2001 03:26:30
|
|
I understand SQL Server DTSs can be saved as VB files (.bas) and quite
possibly, I'm sure, this means I can create a DLL that I can call from ASP
but... is there an easier way to run a DTS from ASP?
Thank you!
Message #2 by "Tomm Matthis" <matthis@b...> on Thu, 22 Mar 2001 09:41:24 -0500
|
|
You can call WSH to run the vbs package...
Tomm
> -----Original Message-----
> From: pzahos@s... [mailto:pzahos@s...]
> Sent: Thursday, March 22, 2001 3:27 AM
> To: ASP Databases
> Subject: [asp_databases] SQL Server DTS from ASP?
>
>
> I understand SQL Server DTSs can be saved as VB files (.bas) and quite
> possibly, I'm sure, this means I can create a DLL that I can call
> from ASP
> but... is there an easier way to run a DTS from ASP?
>
> Thank you!
>
>
Message #3 by "Blake, Shane" <Shane.Blake@p...> on Thu, 22 Mar 2001 14:42:58 -0500
|
|
yes... you can use the following to get you started :
set oPackage = server.createobject("DTS.Package")
oPackage.LoadFromSQLServer ServerName, Login, Password, false, , , ,
PackageName
oPackage.Execute
good luck and let me know if that works cause i didn't get a chance to test
it...
(this, of course, assumes you've got the sql server or desktop tools
installed on the webserver...)
shane
raleigh, nc
-----Original Message-----
From: pzahos@s... [mailto:pzahos@s...]
Sent: Wednesday, March 21, 2001 10:27 PM
To: ASP Databases
Subject: [asp_databases] SQL Server DTS from ASP?
I understand SQL Server DTSs can be saved as VB files (.bas) and quite
possibly, I'm sure, this means I can create a DLL that I can call from ASP
but... is there an easier way to run a DTS from ASP?
Thank you!
Message #4 by Peter Zahos <pzahos@s...> on Fri, 23 Mar 2001 10:21:49 +0800
|
|
Thanks for that! It's exactly what I was looking for. I'll need to tweak
the object to get it to work though. I'm sure I can get it working.
In the meantime, because of the pace of this job, I've resorted to stored
procedures.
Thanks again
Pete
-----Original Message-----
From: Blake, Shane [mailto:Shane.Blake@p...]
Sent: Friday, 23 March 2001 3:43 AM
To: ASP Databases
Subject: [asp_databases] RE: SQL Server DTS from ASP?
yes... you can use the following to get you started :
set oPackage = server.createobject("DTS.Package")
oPackage.LoadFromSQLServer ServerName, Login, Password, false, , , ,
PackageName
oPackage.Execute
good luck and let me know if that works cause i didn't get a chance to test
it...
(this, of course, assumes you've got the sql server or desktop tools
installed on the webserver...)
shane
raleigh, nc
-----Original Message-----
From: pzahos@s... [mailto:pzahos@s...]
Sent: Wednesday, March 21, 2001 10:27 PM
To: ASP Databases
Subject: [asp_databases] SQL Server DTS from ASP?
I understand SQL Server DTSs can be saved as VB files (.bas) and quite
possibly, I'm sure, this means I can create a DLL that I can call from ASP
but... is there an easier way to run a DTS from ASP?
Thank you!
|
|
|
View Cart
