Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft SQL Server

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old July 9th, 2002, 09:36 PM
amucino amucino is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2002
Posts: 1 amucino User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Question Run DTS from ASP

Hello,

Sorry to bother you, I was reading the article, that shows how to run the DTS from an ASP.

And Actually when I run the page locally it works fine, my DTS runs smoothly.

But, when I upload it to the web server it fails. Database has the same username and password, DTS has the same name .. just like in my development computer.

But it still fails. .. I included the code below. Is this common ? .. Is there anything in special I need to change or doublecheck ?

I appreciate your help.
Code:
<%
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)", "amucinoariastovar", "password", DTSSQLStgFlag_Default, "", "", "", "AriasTovarCMSEILA" 
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 
%> 
Regards,

Alejandro Mucino

Reply With Quote
  #2  
Old July 11th, 2002, 01:36 PM
mojo mojo is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2002
Posts: 1 mojo User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
i have the same problem as well, although it worked with a simple DTS task, it did not work with a more complex db copy that works fine from enterprise manager. any solutions yet???

Reply With Quote
  #3  
Old May 26th, 2004, 10:30 AM
raykwatts raykwatts is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2004
Posts: 1 raykwatts User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Lightbulb

make sure to run the web app out of process as a user who has permission to execute the DTS on the database.

Reply With Quote
  #4  
Old June 23rd, 2004, 09:57 AM
twilborn twilborn is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jun 2004
Posts: 1 twilborn User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Asp Dts

I have a web page executes a DTS package successfully,
It imports data from Excel into SQL Server. The Exact
same page fails when trying to run a DTS package that
copies data from one SQL Server table to another.

Any help will be appreciated.

twilborn

Reply With Quote
  #5  
Old April 15th, 2005, 02:24 PM
.riCkStoNe .riCkStoNe is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2005
Posts: 1 .riCkStoNe User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 m 48 sec
Reputation Power: 0
Thumbs up Error in DTS Execute

well this is my first post the error is the same for me.. i only change the user name and pasword in connection (OLE DB PROVIDER, ETC).. SQL DTS Designer.. not windows authentication SQL Server Authentication and runs like hell..

Saludos desde mexico...

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft SQL Server > Run DTS from ASP


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway
Stay green...Green IT