Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
| Search | Today's Posts | Mark Forums Read
SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS 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
  #1 (permalink)  
Old July 15th, 2004, 06:08 PM
Registered User
 
Join Date: Jul 2004
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default execute a package from ASP

Hi, every one!

I am a beginner for SQL server and starting to learn DTS. I copied one program as following and tried to run it, it gives me error message as "Server object error 'ASP 0178 : 80070005'

Server.CreateObject Access Error

The call to Server.CreateObject failed while checking permissions. Access is denied to this object. "

what can I do to fix it? Thanks a lot for advice.


<html>
<head>
<title>Sales Report DTS Package</title>
</head>
<body bgcolor="#FFFFFF">
<%

dim objDTSPackage
dim objDTSStep
dim strResult
dim blnSucceeded

const DTSSQLStgFlag_Default = 0
const DTSStepExecResult_Failure = 1

set objDTSPackage = server.createobject("DTS.Package")
blnSucceeded = true

objDTSPackage.LoadFromSQLServer"(local)", "sa", "", DTSSQLStgFlag_Default, "", "", "", "SalesPkg"
objDTSPackage.GlobalVariables("gPaymentTerm").Valu e = "Net 30"
objDTSPackage.Execute

for each objDTSStep in objDTSPackage.Steps
if objDTSStep.ExecutionResult = DTSStepExecResult_Failure then
strResult = strResult & "Package "& objDTSStep.Name & " failed.<br>"
blnSucceeded = false
else
strResult = strResult & "Package " & objDTSStep.Name & "succeeded.<br>"
end if
next

if blnSucceeded then
Response.Write "<h1>Package Succeeded</h1>"
else
Response.Write "<h1>Package failed</h1>"
end if

Response.Write strResult

%>
</body>
</html>


  #2 (permalink)  
Old July 16th, 2004, 05:23 PM
Registered User
 
Join Date: Apr 2004
Location: Gilbert, AZ, USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to bizzeau Send a message via MSN to bizzeau
Default

Do you have the DTS runtime DLL's installed on the machine running the web server?

Beau Frusetta
SQL Server DBA/Developer
Web/Desktop Application Developer
Unicorn Financial Services/Contractor For Hire
(480) 980-1611
bizzeau@hotmail.com
  #3 (permalink)  
Old July 19th, 2004, 04:54 PM
Registered User
 
Join Date: Jul 2004
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you so much for your input, bizzeau!!!

I am really a beginner and I don't even know if I have the DTS runtime DLL's installed on the machine or not. Could you please tell me how to check if I have them or not, which directory I should look and what files I should check?

Thanks a lot.



Similar Threads
Thread Thread Starter Forum Replies Last Post
Deployment - Execute Package task carumuga SQL Server DTS 0 October 3rd, 2008 07:43 AM
Execute SSIS Package from ASP.NET ghari ASP.NET 1.0 and 1.1 Professional 0 June 11th, 2007 12:51 AM
Execute Package Error dgosche BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 2 February 13th, 2006 12:14 PM
Execute Package hortoristic SQL Server 2000 0 January 12th, 2004 01:52 PM
Execute Package hortoristic SQL Server DTS 0 January 12th, 2004 01:48 PM





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