Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
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
Old July 15th, 2004, 06:08 PM
Registered User
Join Date: Jul 2004
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.

<title>Sales Report DTS Package</title>
<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"

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

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

Response.Write strResult


Old July 16th, 2004, 05:23 PM
Registered User
Join Date: Apr 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to bizzeau Send a message via MSN to bizzeau

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
Old July 19th, 2004, 04:54 PM
Registered User
Join Date: Jul 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts

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.