Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases 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 January 18th, 2005, 12:31 PM
Authorized User
 
Join Date: Sep 2004
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts
Default Run DTS from ASP

Does anyone know what it takes to execute a DTS package from classic ASP?

I know it involves IIS and DTS permissions and specific ASP codes. But I don't know exactly what needs to be done on IIS, DTS (or SQL Server) and ASP codes.

I'm trying to use LoadFromSQLServer from ASP and I use NT authentication in IIS. But I know little about DTS. Can someone show me the right way to make it work?

One of the error messages I've received currently is, "Step [DTSStep_DTSDataPumpTask_1] failed". In another try, I hardcoded my NT login and password, which has is a SQL Server Admin, but it doesn't work either. I have read MSDN how-to, but I just don't understand it.

Please help.



 
Old January 18th, 2005, 01:12 PM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 303
Thanks: 0
Thanked 0 Times in 0 Posts
Default


http://support.microsoft.com/default...EN-US;Q252987&

 
Old January 18th, 2005, 01:14 PM
Authorized User
 
Join Date: Sep 2004
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you, I know and read this article, but it didn't work for me - either I don't get it or something more need to be done there. Thanks.






Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I run or not run Google AD in my ASP.NET w mycwcgr ASP.NET 2.0 Professional 0 November 5th, 2007 07:18 AM
DTS package - passing values at run time kkrish SQL Server 2000 1 June 20th, 2006 04:56 PM
DTS Log detail with Run Status 0 Nicos SQL Server DTS 0 March 3rd, 2006 11:18 AM
Problem to run delete and exec DTS in Stored Proc tyh79 SQL Server DTS 7 July 14th, 2004 10:27 AM
RUN DTS from Stored Procedure AyatKh SQL Server DTS 2 April 11th, 2004 11:44 AM





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